cancel
Showing results for 
Search instead for 
Did you mean: 

Direct Query NO LOCK

I am trying to use a table (Direct Query) with NO LOCK  hint in the query and it is not working.

Query in Advanced Editor:

let
Source = Sql.Database("servername", "databasename", [Query="select * from tablename nolock"])
in
Source

Apparently, it works on PBI desktop and service but when I upload the report on the company's portal and open a transaction on SQL the data doesn't appear in the report. The data appears only after the transactions are committed or rollback.

Status: New
Comments
Moderator

Hi @mariboeira

 

How do you embed the report in your company's portal? From your description, it looks like the issue doesn't happen with Power BI desktop and service. When you do the transaction in SQL database, please refresh the report in your company portal to check if the report load data fine. 

 

Best Regards,

Qiuyun Yu