Direct Query NO LOCK

[mubp]

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.

[v-qiuyu-msft]

Hi @mubp, 

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