Forum Discussion
SQ Read Uncommitted connection
We absolutely cannot block users from entering data so have added the READ UNCOMMITTED syntax to our SQL query that is getting our data into Power BI Desktop. I understand that the data may be dirty ...
We ran into a similar problem as well. All queries that submitted by PowerBI does not do an uncommitted read for any query that it is doing against the database server (in my case it was SQL Server). I enabled profiling and did few checks and right from the query that is submitted to get the list of database, schemas, tables etc to the any transformation quires we do after selecting the tables needed does not do an un committed read.
Anyone has any alternatives for this situation?