Forum Discussion
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.
Hello,
Did anyone have a solution to this issue? Because I had the similar issue too - scheduled refresh was complete but data was not updated completely.
I had to trigger the "refresh now" manually on my dataflow in powerbi service and data was updated..
Not sure why this is happening, it works fine sometimes, but now this problem kept occurring after rescheduled data refresh in the morning..
Hi Anonymous , I'll copy in my solution I posted earlier that worked for my team.
Hi everyone, I thought I'd weigh in on a solution I found to a similar issue. Our underlying data sources was primarily a DataFlow, however we also did have a few other alternative sources such as Excel spreadsheets that we accessed. Similarly, we were able to refresh the report manually via the PowerBI Desktop. Our DataFlow would successfully refresh when it was scheduled via the Web Service, however the report itself would not update.
The solution we found was that both the DataFlow and the DataSet need to be refreshed in Power BI Web. Refreshing only one of these meant that the underlying data would not be completely updated, therefore preventing the report from being updated. We then made sure to schedule a refresh for both data sources which successfully resolved the issue. An important note is that you should stagger the scheduling as the Web Service can take 5 to 10 minutes to completely refresh the data source (or longer, dependent on how much data you have. For example, we scheduled the DataFlow to refresh at 8:00am and the DataSet to refresh at 8:30am, so that the report will be updated by 9:00am every morning.
Also, make sure that your gateways are correctly setup.
Glorfendal thanks for sharing your solution.
Currently, my dataset and dataflow scheduled data refresh is staggered, so this is not the root cause.
After my dataflow had a completed scheduled data refresh, I realized the data was only updated to a certain date rather than to the latest available data when I connected the dataflow in power bi desktop.
However, if I triggered the "refresh now" button on powerbi service, the dataflow is updated to the latest date.
StevePBennettAdvocate I
Thank You Glorfendal,
You solved why my Power BI Reports were not getting updated with refreshed data.
I was missing the fact that the DataFlow needed to be refreshed before the DataSet. i.e. As a paired set.
Many thanks.
SteveB