Forum Discussion
Power BI Report Server RLS is error while query is passed to DB.
RLS error sometimes occurs when reports are run in Power BI Report Server. In order to track what query is transferred to the database, we installed Profiler on MSSQL. As a result, we got that query...
Hi DariaM ,
Sorry I can't reproduce your problem locally, would you try opening the report locally in Desktop and using view as roles to get the same problem?
Best Regards
Lucien
Good afternoon!
We use PBIRS with a request through "DirectQuery". Manager roles don't work in desktop version in this situation.
The problem started in March and it continues to this day. Updated to the latest version "May 2022". The problem occurs randomly on different reports.
