A Power BI dataset can operate in one of the following modes to access data from a variety of data sources.
Detailed explanation can be found in the video session below.
Do You Always Need Refresh?
Based on the image below, you only need Data refresh if you are using the Import Storage Mode
Installing Personal Data Gateway
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.
Will Data Gateway Automatically Update My Reports?
Data Gateway will only make sure the dataset is accessible and through configured refresh, it can always remain updated. When you make changes to your Power BI report on the Desktop version, you will have to republish to update the online version.
Watch the Session
In this live video session, you will be able to tie together all these topics with practical demonstration of these concepts.