Reply
Frequent Visitor
Posts: 2
Registered: ‎10-02-2018
Accepted Solution

Scheduled Refresh Succeeds but Data Won't Update

I have built a Power BI report that queries data from a SQL Server database at my organization. I've uploaded the report to Power BI online and set up a scheduled refresh with the help of our IT staff. Everything is showing as "green" and I get confirmation that the data refresh succeeds each time it's set to occur. There is no error message or other notification that the refresh failed. HOWEVER, the actual data in the report does not update to reflect the most current data in our SQL Server database. 

 

When I go into Power BI Desktop and hit the "Refresh" button on the report manually, the data DOES update and show correctly based on the current data in the SQL Server databse. 

 

Is there a way to fix this issue so that the scheduled refresh in Power BI will actually update based on the most current data in our database? 


Accepted Solutions
Highlighted
Super User
Posts: 3,484
Registered: ‎06-25-2015

Re: Scheduled Refresh Succeeds but Data Won't Update

@spinachbisque How quickly are you checking the report after the dataset has said it has refreshed? The Dataset, Report and dashboard are seperate objects and are not all immediately refreshed after the dataset. It is in order. If the dataset refreshes, it is likely it will be 10-15 before the report, and then the Dashboard. You can also initiate a refresh in the report after the dataset.

If you know, and or tried the above, then this sounds like a bug or issue that you should raise in a support ticket or the issues page.

Near SE WI? Join our PUG MSBIWI

View solution in original post


All Replies
Highlighted
Super User
Posts: 3,484
Registered: ‎06-25-2015

Re: Scheduled Refresh Succeeds but Data Won't Update

@spinachbisque How quickly are you checking the report after the dataset has said it has refreshed? The Dataset, Report and dashboard are seperate objects and are not all immediately refreshed after the dataset. It is in order. If the dataset refreshes, it is likely it will be 10-15 before the report, and then the Dashboard. You can also initiate a refresh in the report after the dataset.

If you know, and or tried the above, then this sounds like a bug or issue that you should raise in a support ticket or the issues page.

Near SE WI? Join our PUG MSBIWI