Forum Discussion
Cannot refresh from Sharepoint Online Excel file in Power BI Service, only in Power BI Desktop
Microsoft EmployeeHi Vi12
If the data source in the report is your local file, not the file in the SharePoint online, though you set the schedule refresh for the dataset, it retrieves data from local Excel instead of SharePoint Excel file. If you want to set the schedule refresh to retrieve data from SharePoint Excel, I suggest you to refer to below steps:
1.Upload your excel file to the SharePoint online
2.Create a report in Power BI desktop by getting this file in SharePoint online. Reference: https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
3.Publish the report to the service and you can set the schedule refresh. Reference: https://docs.microsoft.com/en-us/power-bi/refresh-csv-file-onedrive#what-are-the-advantages
Regards,
Thanks Cherie.
I am already linking to the Sharepoint file, not a local file. I have checked this by changing data in the sharepoint file, and the changes are reflected after a refresh in the PBI Desktop. This is what puzzles me: why the same report manages to load from the sharepoint file in Desktop, but not after being oublished to the Service.
Have tried to recreate the same report from scratch using the same Sharepoint file. Then everything works as expected. Hoever I still do not understand why the original report does not work as I can see no differences in how they are implemented. My worry is that the same problem will reoccur in the new report, since two existing reports have had the same issue. Recreating the report is a time consuming. workaround....
By the way I am not using a scheduled refresh in the Service, but manually refresh when needed.
