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.
Hello: my power BI report in the app (workspace) doesn't sync/refresh with the latest data of the excel spreadhseet located in Sharepoint. I have to go to Power BI desktop, click refresh and publish it again so that it shows in the Power BI app report. This is very inneficient. The idea is that when we change the data in the excel spreadsheet in the Sharepoint, anybody that has access to the report, can click refresh in the Power Bi app and see the changes. However, This is not the case. The power BI report has auto-refresh enable but it doesn't update anything. Can you please advise?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Bfreire ,
I have done a test, also adding a new column to the excel data source, the refresh does not show up; if you simply change a number value in the data source, the refresh is successful.
Therefore, in the service, the data refresh is a test of whether the metadata has changed, that is, it only refreshes the data set that you have uploaded to the service. If you add new columns or tables to the data source, as you have done, in the excel source, this cannot be refreshed.
When you open the dataset, what is shown on the right side is the metadata,like this:
So I think you need to go with a re-upload.
Best regards,
Community Support Team Selina zhu