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.