ODBC Schedule Refresh Report not Updating Visualisations

[neilgeorge]

Hi guys, i'm looking for some much needed guidance, I have a schedule refresh setup on an ODBC dataset which has a dashboard report created off it, for some reason the dataset and report show that they have been refreshed at the same time successfully but the visualisations within the reports have not updated. 

If I open up the reports, press edit and then refresh, all the visualisations update to contain the correct updated data, but this of course is a manual task the scheduled refresh is there to avoid.

Any idea on what could be up here and if the reports can be updated automatically?

Like I said, any help would be really appreicated!

[Anonymous]

Hi @neilgeorge ,

The reason for this is that Service maintains a separate cache for report to ensure that users can open and view reports as the dataset is refreshed, and it overwrites the cache with new data after the dataset has been successfully refreshed for a period of time, which is usually not long. Of course you can also click Refresh in the report to synchronize the cache immediately. 

Power BI Security

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum