Forum Discussion
Data Connections with NOLOCK
I haven't been able to find the answers to a couple NOLOCK questions: SQL Connection: I know that when you establish a SQL connection in PBI Desktop, you can specifiy a query in which you can ad...
I've created a request through the ideas forum. Worth commenting/liking it if you want to see some development on this.
Hi,
Similar thoughts to yourselves.
I had a situation where Power BI locked up one of our databases. I am assuming that if I preface any of my queries with SELECT * FROM X WITH(NOLOCK) as I bring the data into Power Query before doing whatever else transformations that this should get around this issue?
Can anyone confirm the use of NOLOCK solving this issue?
