Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I created a report on BI Desktop and datasource is SharePoint Online. After publishing the report to app.powerbi.com the refresh function won't work. Could I get some help to suggestion to diagnose what went wrong?
Hi @Anonymous ,
1.If your dataset only contains SharePoint on line data source and doesn't contain any on premise data source, then it needn't to use the gateway.
You can manually refresh the dataset by using Refresh now or you can set up a refresh schedule by using Schedule Refresh. Power BI automatically connects to the workbook on OneDrive, or SharePoint Online, about every hour to check for updates. If the workbook has changed, Power BI will refresh the dataset and reports in the Power BI service.
2.If your dataset not only contains SharePoint on line data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .
Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
Or could you please show us the refresh history information for further analysis?
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So the refresh icon on the report page does not work.
The Refresh Now icon in Datasets Tab would work and all datasources including the relationship tables are from SharePoint Online.
Does this mean there is no need for Gateway Cluster Settings?
Unable to set credentials, the tab is greyed out.
Datasource is not connected to gateway. It is connected to SharePoint online list.
Wasn't refreshing at all. When refreshing on BI Desktop it would took a good 3-4 minutes but when refreshing BI online it took literally just seconds, doubt if the connection has been cut short somehow.
Same issue here, When I hit refresh button of an online package, looks like the restart is starting, but after 2 seconds it's 'finished'.
Normally this refresh takes about an hour....
Would be great to understand if this is a wider issue....
Seems to be resolved (by itself) now on our side!
Please share the success recepie or tips!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.