cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpowerrajesh365
Helper I
Helper I

Dataflow chain refresh error - lock model

I have 3 Dataflows created which basically brings tables from 3 different sources.

Then I tried to create a Transformation Dataflow in which I am using all the linked tables coming from earlier Dataflows.

 

While I try to schedule these 3 Dataflows at the same time say for example DF1, DF2, DF3 at 8:00 it's getting failed due to below error.

 

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

 

Does this mean I can't refresh all the three DF's at the same time? I don't want to wait for 30 mins interval for second DF to refresh and consecutively another 30 mins for next.

 

Can I know why is this happening please?

 

2 REPLIES 2
mpowerrajesh365
Helper I
Helper I

The Sources I am using are MYSQL, SQL On Premesis, Sharepoint. Only one out these will be successful as the other will throw the below error.

Anything to do with gateway settings? This is strange.

 

The Transformation Dataflow will auto refresh soon after actual DF1, DF2, DF3 starts refresh as I am using linked Entities from them as said above. Thanks for your help

Hi @mpowerrajesh365 

I found some blogs about refresh dataflow, I hope they could help you.

Blog1: Dataflows in Power BI: Overview Part 5 – Data Refresh

Blog2: Dataflows - Refresh Dataflow

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors