Hi I have been reading about data gateways and automatic refreshing of data sets for both PowerBI desktop files as well as PowerBI Service. I understand the majority of what is being provided however I am still slightly unsure of things.
If I have an ODBC connection to an SQL database stored on premise (in my organisation) and create a set of reports in PowerBI desktop and push these reports into an app space/ work space in PowerBI Service, what is the preferred method of being able to automatically refresh data in the desktop and service version. I understand refreshing purely from the service will just query the desktop file which if that has not been refreshed then it is pointless. But I do not want to have to refresh and upload every report everyday.
My understanding is to use a data gateway, however, some points/ functionality of the gateway I did not understand.
Microsoft’s Explanation - https://docs.microsoft.com/en-us/power-bi/refresh-data#types-of-refresh