Forum Discussion
Power BI Service Refresh
You need to do the following:
- Install a data gateway: Install an on-premises data gateway | Microsoft Learn
- Configure the data gateway: Use the on-premises data gateway app | Microsoft Learn
- Create a connection on that data gateway that is for the data source you are using in your PBIX file: Add or remove a gateway data source - Power BI | Microsoft Learn
- Map your data source in the PBIX to the data connection on the gateway
So, yes, a data gateway is what you need to automated refreshes of data on local systems. When you configure the data gateway you can authenticate via multi-factor. Multi-factor should not come into play when accessing your Excel files. If you do have some kind of issue with this, you will likely need to use some sort of service account and exempt that account from MFA.
Hi,
If you have a data gateway setup and running, you can schedule a refresh. Under the semantic model settings, you will find the refresh section. You can set it up to run daily
Data refresh in Power BI - Power BI | Microsoft Learn
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Hi,
If you have a data gateway setup and running, you can schedule a refresh. Under the semantic model settings, you will find the refresh section. You can set it up to run daily
Data refresh in Power BI - Power BI | Microsoft Learn
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!