Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
3 | |
3 |