Forum Discussion
published report won't refresh
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?
12 Replies
- Hi there
Did you configure the data source credentials for your published report?
If not you will have to go into the report settings, then look under Data Source Credentials and put in the required credentials.- Hi there
Is the datasource connected to a Gateway?
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.
- Hi there,
The refresh button on the report page only refreshes the meta data for the report. It DOES NOT refresh the dataset.
In order to refresh the dataset, you have to go into the dataset and then click on Refresh Now
