Forum Discussion
Power BI refresh
- 1 year ago
Hi Anonymous ,
Go to Power BI Service: https://app.powerbi.com
Navigate to your workspace where the report is published.
Under the "Datasets + dataflows" section, locate your dataset.
Click on the ellipsis (three dots) next to the dataset > choose "Settings".
Under "Data source credentials", check each listed source:
- Click "Edit Credentials"
- Choose the correct authentication method (e.g., OAuth2, Basic, Windows)
- Enter credentials and save
Once all credentials are set, scroll to "Scheduled refresh" and toggle it On.
Set your preferred refresh frequency and save.
HI Anonymous,
Thank you for the question.
Based on your description, it appears Power BI is incorrectly routing cloud sources like SharePoint or Dataflows through your on-premises gateway, which is not required and can prevent refreshes. This typically happens when source paths overlap or cloud credentials are missing.
To resolve this, ensure your Azure File Share uses a UNC path and is correctly mapped under the gateway. Then, in the Power BI Service, go to Dataset settings and then Data source credentials, and authenticate each cloud source (like SharePoint) separately using OAuth2. Cloud sources should not be part of the gateway configuration. Once this separation is in place, the refresh should work as expected.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you for using Microsoft Fabric Community Forum.
Thank you very much for the quick response.
Have a good day.
Thank you