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...
In terms of connecting to a SQL table, I'm interested in exactly the same thing regarding the use of NOLOCKS. Even using a Data warehouse, we don't just update it once overnight, so knowing NOLOCKS are being used is really important. It's likely to cause performance issues as we roll Power BI out into the business.
More and more businesses are moving away from a single overnight refresh so I can imagine this becoming more of an issue.