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.
Did anyone get an update on this issue? I ran a search as I think I'm experiencing the same thing.
The most notable thing I noticed is I relegated my ETL on one of my key fact tables to Data Flows. The DF updates successfully in PBI Service but doesn't show up in the corresponding Dataset, even if I do an on-demand refresh. The weird thing is, when I manually refresh the DF within Power BI Desktop, it does indeed show the updated data. I'm wondering if it's anything to do with:
- The Dataflow is pulling data from SQL Server with a Gateway (note I don't get any errors, the data pull is successful as confirmed with a manual refresh in PBI Desktop)
- The dashboard is pulling data from multiple DFs (10+) with different intervals set for auto-refresh
I've used DFs for a long time and this is the first time I've encountered this issue. It's a weird one and if it's indeed a bug, it's a big flaw...
Did you ever find a resolution for this? Working on Premium capacity and running into same issue. A dataset has several dataflows as source data, as well as a SharePoint list. The Dataflows all are refreshing successfully in the online service and data can be queried successfully. The dataset and report fully load data in the PBI Desktop app. When publishing to Online service, the data only refreshes up to a certain date, and will not load any data beyond that date. Manual and scheduled refresh show as successful, but the data will not populate in the online service dataset, even though it is a successful refresh and data is available in Dataflow