Issues with refresh in Power BI Online using Sharepoint lists

[MarieD]

Hi all,

I have made a Power BI dashboard that uses some Exel files as datasource. These files are stored in a Sharepoint folder and will be refreshed every 2 hours automatically. Only the newest versions will be in that folder, it will overwrite the previous file.

Now I have set up the dataset in Power BI online to be refreshed every 2 hours between 7am and 5pm. 

So for example this morning, the Sharepoint file was update at 6.30h so with the refreshed sceduled at 7.00, I expected to see the information from 6.30h in my report after refreshing at 7.00h. However, it was showing information from 5.30. While I cant even see the 5.30h file in Sharepoint folder, as this was already replaced by the 6.30h file.

Then I opened and refereshed the Power BI desktop file and this was giving me the expected result for 6.30h file.

Manually refreshing in Power BI Online doesnt help, it keeps looking back at a previous version.

Does anybody has an idea how this can be solved?

Kind regards, Marieke

[v-kkf-msft]

Hi @MarieD ,

Has the dataset been refreshed successfully? Has the associated report data been updated?

Sometimes the dashboards do not show the latest data, and you may need to click the "Refresh Visuals" button to load the latest data from the tiles cache.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nickyvv]

Hi @MarieD,

It's probably not the answer you want/need, but I don't like (to use) SharePoint as a source for Power BI...

Often it's slow in refreshing and it might take longer then the actual refresh time of your PBI report (your problem). I'm not sure if this is a caching issue in SP, or something else.

That being said, this doesn't really help you, but that's all you can work with. You could set the refresh schedule to a later time (so more than 30 minutes) to see if that helps.