SQL No Lock Query

[Anonymous]

Hello,

I am currently trying to connect into a data warehouse and import its views using a SQL query. since we have scheduled refreshes for different dashboards in the same hour, it was suggested that I include a NoLock in the source query.

I have tried the below statement on power query but it is not working, could anyone suggest me the correct one ?

Thank you in advance!

[daxer-almighty]

@Anonymous 

As a T-SQL veteran (15+ years of hardcore experience) I can tell you one thing: you should never use the hint NOLOCK. NEVER. If someone tells you to the contrary... then they don't have the foggiest idea what they advocate. But it's your choice.

By the way, readers never block readers on tables. Readers can only be blocked by writers. And such blocks should last for a split second, not more. If you have a problem with writers, then you should not use NOLOCK but rather run your query under the SNAPSHOT isolation level.

[v-yingjl · Accepted solution]

Hi @Anonymous ,

You can refer this blog and viedo which introduce NOLock in power query:

1. Solving NOLOCK SQL Power BI issues with Sample Code for STEEMSQL 
2. Solving NOLOCK SQL Power BI issues 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

Many SQL commands are not available in Power Query, and you are really harming the performance of your query by using select * from. 

Commands like delete, update, etc. are not available either. I don't think Power Query locks anything anyway - it is just a query of the view. If they want to put the no-lock in their view definition that is what should be done.