Error while refreshing multiple dataflows at same time

[Sparsh]

Hi community ,

I am new to powerbi and facing this particular issue where i need to refresh my 9 dataflows daily b/w 2-9 AM 

From few days I am getting an issue when more than 1 dataflow is refreshing at same time . I have set some schedule refresh for each hour and I am observing that if a dataflow is taking more than one hour to refresh and meanwhile my second dataflow starts refreshing, I am getting an error for my second dataflow which states 

"Cannot acquire lock for model because it is currently in use."

I would like to know why this error comes and if I can possibly refresh multiple dataflows at same time

My data source is a Snowflake Database for all my dataflows . Also there is a gateway connection built using a vm server to connect to source data

[Anonymous]

Hi @Sparsh ,

If a dataflow takes longer than expected to refresh and another dataflow starts refreshing during this time, the second dataflow may fail to acquire the lock, leading to the error you’re seeing.

If possible, adjust the refresh schedules of your dataflows to ensure they do not overlap. This might involve setting up a delay between the refreshes of different dataflows.

You may also try to optimize your dataflows, review your dataflows to identify any opportunities for optimization that could reduce their refresh times. This could involve steps like filtering data earlier in the process, reducing the number of columns, or optimizing calculations.

Data Flow refresh failing with Error : Cannot acqu... - Microsoft Fabric Community

locking - Has anyone used No Lock with Power BI? - Stack Overflow

Best regards.
Community Support Team_Caitlyn

[Sparsh]

Hi @aj1973 Thanks for the reply , but I would like to tell you that I am A PPU user of powerbi 

Secondly I am refreshing 9 different dataflows once daily . The problem is not the limit . I have scheduled all of them at different times . The problem is if the refreshes of any two dataflows overlaps , I get the above error

[aj1973]

Is there entity or entities that are coming from same source and loaded to 2 different Dataflows? 

[Sparsh]

Yes all the 9 dataflows have same data source snowflake db 

but all 9 dataflows have different tables and i am using different sql queries to fetch data 

[aj1973]

Hi @Sparsh 

Your 9 Dataflows fell into this limitation

you can refer to this for optimization

Understand and optimize dataflows refresh - Power BI | Microsoft Learn