Dataflows Question

[Anonymous]

Team,

I have several dataflows setup and they run well.

I am now looking at using the Linked Table feature so that I have dataflows where I can pair the data down for specific use cases and limit the number of records in certain circumstance.

During my automatic refresh schedule, several of the tables that are linked tables are getting record lock errors and then failing. They will work if I go back in and refresh individually, however I can’t figure out why this is happening.

Do you have any suggestions on what I can do to be able to take advantage of this nice feature where the data will be consistent?

Thank you!

[Anonymous · Accepted solution]

Hi @Anonymous ,

One possible reason for the record lock errors during the automatic refresh schedule is that multiple dataflows are trying to access the same entity simultaneously.

One possible solution is to adjust the refresh settings for your dataflows to stagger the refreshes of your linked tables. You can also try increasing the timeout settings for your dataflows to give them more time to complete the refresh process. Additionally, you can check if there are any other processes or queries running on the same data sources that may be causing conflicts with your dataflows. It may also be helpful to review the logs or error messages generated during the refresh process to identify any specific issues that may be causing the record lock errors.

Best Regards,

Neeko Tang

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

[Anonymous · Accepted solution]

Hi @Anonymous ,

One possible reason for the record lock errors during the automatic refresh schedule is that multiple dataflows are trying to access the same entity simultaneously.

One possible solution is to adjust the refresh settings for your dataflows to stagger the refreshes of your linked tables. You can also try increasing the timeout settings for your dataflows to give them more time to complete the refresh process. Additionally, you can check if there are any other processes or queries running on the same data sources that may be causing conflicts with your dataflows. It may also be helpful to review the logs or error messages generated during the refresh process to identify any specific issues that may be causing the record lock errors.

Best Regards,

Neeko Tang

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

[Anonymous]

Hi @Anonymous ,

Thanks for the reply! Can you please let us know where i can go and adjust the refresh settings and timeout settings for my dataflows. If you any articles related to refresh settings and timeout settings please share with me.

Thanks in advance!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can refer to the following documents that may be helpful to you:

Configure and consume a dataflow - Power BI | Microsoft Learn

Understand and optimize dataflows refresh - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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