Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 and we'll live with that until the blocking issue is resolved.
My question is about the READ UNCOMMITTED--I learned that the syntax applies for SQL per session/connection. Is it the same for Power BI Desktop? In other words, when in a SQL statement that is importing data does the READ UNCOMMITTED cause the Desktop connection to 'read uncommitted' for any subsequent SQL statements used to import data? Is it necessary to end the connection for that command to be "cleared"?
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?
You may try connecting SQL Server Profiler to Power BI Desktop.
Thank you for the suggestion! I tried to open the SQL Server Profiler but I get the error message:
"In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission."
My role has limited permissions and is the reason why I can't block users.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |