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 ...
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.