Forum Discussion
Prevent database locking using direct query in Power BI
I have a question regarding how to prevent locking a database if i'm using DirectQuery in PowerBI. Steps: I select a server and database and click OK and don't enter sql syntax in the Advanced ...
Hi, ptepichin ;
You can check if these related post can is useful to you.
DirectQuery model troubleshooting in Power BI Desktop - Power BI | Microsoft Learn
Resolve blocking problem caused by lock escalation - SQL Server | Microsoft Learn
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your response. It's very useful. In addition do you know if I need to do further configuration on power bi desktop on the datasets to prevent locking similar to using WITH(NoLock) in the sql query?