Forum Discussion
Dataflows Question
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!
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.
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.
3 Replies
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.
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.