Forum Discussion
Dataset not updating
I've rebuilt the entire workspace, by exporting and importing the dataflows and updating the tables sources.
This seems to have solved the issue, will monitor for some time to be sure.
Very strange...
Thanks for the response JoeBarry!
The source of the extract dataflow (outside Power BI), updates continuously. This extract dataflow takes a snapshot every hour. Then the chained transform dataflow automatically refresh as well. This takes about 1 minute. When I look at the data in this transform dataflow, everything is as expected. Both have load enabled.
It's only at the next stage, the dataset in workspace B, where the data is outdated. So I have both actual data (workspace A) and outdated data (workspace B). All of this happens within the Power BI Service, same tentant, but across workspaces. All dataflows and datasets show they're refreshed.
I would say there is an issue with the PA Flow. Maybe check that to see how long it takes to run? If the data is appearing later then it could be related to this.
Maybe there is a Refresh of the dataset running and it can't complete it's task until it finishes. Is there also a scheduled refresh of the dataset setup?The Power Automate Flow takes 7 seconds. It starts after completion of the DataFlow refresh, and refreshes the dataset without issues. There is no scheduled refresh set on the dataset, so there should not be any parallel refreshes taking place.
I've also succesfully manually refreshed the dataset a few times afterwards indeed to rule out it was caused by the PA Flow. Same result.
I've rebuilt the entire workspace, by exporting and importing the dataflows and updating the tables sources.
This seems to have solved the issue, will monitor for some time to be sure.
Very strange...
