Forum Discussion
Dataflows refresh problem
Hello,
Could you please help me to understand what is happening?
Context:
I have 2 workspaces: each of them has dataflows. Data flow in workspace 1 is based on another dataflow from workspace 2.
I have pro licence
Problem:
Since today i have an issues with dataflow refresh. I can see that data in workspace 2 in dataflow is refreshed.
However, my dataflow from workspace 1 is still has data of yesterday (even I tried to refresh in workspace, I tried to edit workflow and click refresh there, but still nothing changes)
Even when I try to create new dataflow and base it only on updated workflow, I still see old data.
I thought it could be related to my licence (since I disabled loading), but before when I clicked refresh in editing mode, I could see new data.
Could you please help me to understand what can block the refresh? Did something change?
Thanks,
Elena
Hi ekoroleva,
Thank you for reaching out to the Microsoft fabric community forum. Thanks Akash_Varuna, for your inputs on this issue.
After thoroughly reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:
Ensure Workspace 2’s dataflow refresh completes before starting Workspace 1’s refresh. Use a scheduled refresh dependency or manually trigger Workspace 1’s refresh after Workspace 2 completes. If Workspace 1’s dataflow lacks a scheduled refresh, it will use old data. Go to Power BI Service → Workspace 1 Dataflow → Settings → Enable refresh schedule. Run a manual refresh to check for new data.
Power BI may cache query results. Turn on Enhanced Compute Engine in Workspace 2’s dataflow. If already on, force a full refresh in Workspace 1’s dataflow. Edit, revalidate, and save the query to ensure fresh data.
If Workspace 1’s dataflow uses a linked table from Workspace 2 and isn’t updating, the link might be inactive. Check Workspace 1’s dataflow for the latest linked table version. Verify Power Query References Workspace 2’s dataflow correctly. Try removing and re-adding the connection.Refresh Workspace 2 first. Once complete, refresh Workspace 1. For scheduled refresh, ensure Workspace 1 refreshes after Workspace 2. Ensure Workspace 1 can read data from Workspace 2 by checking permissions in Workspace 2’s settings. Try a different user account if the issue persists. Power BI may delay dataflow refreshes for large datasets. Wait a few minutes after Workspace 2’s refresh before triggering Workspace 1’s refresh.
For more information kindly refer to the below links:
Dataflows Limitations, restrictions and supported connectors and features - Power BI | Microsoft Learn
Troubleshooting dataflow issue - get data from dataflow - Power Query | Microsoft Learn
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.Thank you.
4 Replies
Hi ekoroleva Could you try these please
- Refresh Workspace 2’s dataflow first, then Workspace 1’s.
- Clear your browser cache and reload Power BI (Ctrl + F5).
- Edit and re-save Workspace 1’s dataflow before refreshing.
Hi ekoroleva,
Thank you for reaching out to the Microsoft fabric community forum. Thanks Akash_Varuna, for your inputs on this issue.
After thoroughly reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:
Ensure Workspace 2’s dataflow refresh completes before starting Workspace 1’s refresh. Use a scheduled refresh dependency or manually trigger Workspace 1’s refresh after Workspace 2 completes. If Workspace 1’s dataflow lacks a scheduled refresh, it will use old data. Go to Power BI Service → Workspace 1 Dataflow → Settings → Enable refresh schedule. Run a manual refresh to check for new data.
Power BI may cache query results. Turn on Enhanced Compute Engine in Workspace 2’s dataflow. If already on, force a full refresh in Workspace 1’s dataflow. Edit, revalidate, and save the query to ensure fresh data.
If Workspace 1’s dataflow uses a linked table from Workspace 2 and isn’t updating, the link might be inactive. Check Workspace 1’s dataflow for the latest linked table version. Verify Power Query References Workspace 2’s dataflow correctly. Try removing and re-adding the connection.Refresh Workspace 2 first. Once complete, refresh Workspace 1. For scheduled refresh, ensure Workspace 1 refreshes after Workspace 2. Ensure Workspace 1 can read data from Workspace 2 by checking permissions in Workspace 2’s settings. Try a different user account if the issue persists. Power BI may delay dataflow refreshes for large datasets. Wait a few minutes after Workspace 2’s refresh before triggering Workspace 1’s refresh.
For more information kindly refer to the below links:
Dataflows Limitations, restrictions and supported connectors and features - Power BI | Microsoft Learn
Troubleshooting dataflow issue - get data from dataflow - Power Query | Microsoft Learn
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.Thank you.
Hi ekoroleva,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hello,
Thanks for your answers,
It works for the moment, I accepted the solution,
Thanks for your help,
Best,
Elena
