Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Report Server Sept 2019 Release - Row Level Secruity using Direct Query problem.

I've been following the instruction posted:
https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server


I've created two roles in power BI desktop and they work correctly.
When I save the PowerBI report to the report server I get the error message.

Row-level security is not available for reports using Direct Query with integrated authentication. Learn more

 

According to: https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server
" You can also configure RLS on reports that use DirectQuery, such as SQL Server. Keep in mind that RLS isn't respected if your DirectQuery connection uses integrated authentication for report readers. "

 

So I changed my Direct Query Connection in the Power BI desktop to database authentication.
However this did not fix the problem.  I guess I don't understand what needs to be configured to get Direct Query with RLS setup.
Can you provide more detail on the configuration to do RLS and Direct Query?


Thanks

RLS Direct Query
  • Anonymous's avatar
    Anonymous
    6 years ago

    I guess the documentation was not clear it's not Datasource in PowerBI Desktop that needs to change. 
    Once uploaded to the Report Server, the datasource must be changed within Report Server to access RLS settings.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I guess the documentation was not clear it's not Datasource in PowerBI Desktop that needs to change. 
    Once uploaded to the Report Server, the datasource must be changed within Report Server to access RLS settings.