Forum Discussion
Power BI Service Refresh error-- Currently in use
Hello All,
I am facing issue with power BI Data flows refresh in premium workspace
I have created three data flows considered as primary---A, B, C
A, B , C Taken intlo Main Data flow and from main Data Flow using tables from it two other data flows are created. All data flows are in same workspace....
Below is my architecture for data flows
I am getting error while refreshing 3 primary at a time, when refreshing any primary data flow main Data flow and linked data flows to main data flows are also refreshing and others 2 primary data flows are failing and showing below error
"ErrorMessage":"Cannot acquire lock for model because it is currently in use."
I tried of keeping 1 half hour difference between each data flow refresh still I saw C data flow has failed refresh and shown above pasted error message
what could be the issue, how to resolve it
what ways I can implement to not get this error
1 Reply
- rajendraongole1
Super User
Hi Anonymous -as per your architecture shared, it seems that the interdependencies between your dataflows are causing concurrent refreshes and locking issues.when multiple refresh operations are trying to access the same dataflow or dataset simultaneously, causing a conflict
Might be the following solution helps you that there is sufficient time between the refresh schedules of your dataflows to avoid overlap like increase the time gap further, especially if the dataflows take longer to refresh than anticipated.Review the transformations and queries in your dataflows. Optimize them to reduce refresh time.
Option 2: Implement a sequential refresh strategy where each dataflow refresh using power automate or azure logic, reduce the dependencies between dataflows to minimize the chain of refreshes.as mentioned your Premium capacity is not over-utilized. Monitor the capacity metrics in the Power BI Admin Portal and consider scaling up if needed.
Hope it helps
