Forum Discussion

spinachbisque's avatar
spinachbisque
New Member
7 years ago
Solved

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 staf...
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

Glorfendal's avatar
Glorfendal
Regular Visitor
5 years ago

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.

StevePBennett's avatar
StevePBennett
Icon for Advocate I rankAdvocate I
5 years ago

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