Forum Discussion
Data Refresh not updating table
I have a scheduled Data Refresh. It was working all good. But since last two days, data is not Refreshing. Refresh Schdule is saying Success in 14 min, but there is no Data in any Reports. If I run the query in SQL Server, it is getting data properly. Even the Desktop version is Refreshing all good.
Any idea why this is happening on Power BI Service (Onine) and how can we fix the issue ? It is impacting one of the Production Report.
try the follow: `
1) check all the table queries, go to properties and be sure all have the update on refresh option seleccted, its just below the option for not loading the querie to the report.
2) Re Publish the PBIx to the service and check all gateways, etc.
3 Replies
- StefanoGrimaldi
Resident Rockstar
try the follow: `
1) check all the table queries, go to properties and be sure all have the update on refresh option seleccted, its just below the option for not loading the querie to the report.
2) Re Publish the PBIx to the service and check all gateways, etc.
Hi StefanoGrimaldi,
I'm facing similar issues. Data is coming from an excel is SharePoint. The excel file is updated everyday. The Power BI Table visual does not pick up the latest data. I have to manually press the "refresh visual" in the power bi report so the visuals can pick up the latest data.
"check all the table queries, go to properties and be sure all have the update on refresh option seleccted, its just below the option for not loading the querie to the report."
- could you please add an SS to locate this option?
Thank You
Hi Anonymous ,
1. Power bi will cache the final state of the visual object. If the report shows outdated data, select the "Refresh" button of the report to trigger the refresh of all report visual effects.
2. You can set to refresh in the browser to get the data automatically, and then you can get the latest data after the scheduled refresh.
Reference: How to Auto Refresh Pages on Google Chrome, Firefox, and Opera (guidingtech.com)
Regarding the content of data refresh, you can check the following documents:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
There are also related content, I hope to help you:
https://community.powerbi.com/t5/Service/dataset-doesn-t-update-when-refresh/m-p/941222
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
