Forum Discussion
Helper IIRLS Not Applying When Added/Saved from Power BI Report Server, but Works After Re-uploading it
Hi Maverik91 ,
You are absolutely right: the behavior you are seeing is consistent with a known limitation in Power BI Report Server. When you use the "Edit in Power BI Desktop" feature directly from the Report Server portal and then save back to the server, the RLS roles may not be properly embedded or refreshed in the report metadata - even though the UI shows them as configured.
To ensure RLS works correctly on Power BI Report Server(Until the issue got fixed):Recommended Workaround is as follows:
Download the .pbix file manually from the Report Server.
Edit it in Power BI Desktop (not via “Edit in Power BI Desktop” from the portal).
Save locally, then upload manually back to the Report Server.This manual upload correctly triggers RLS enforcement, unlike the “Edit from Server and Save” method, which may skip refreshing RLS bindings due to a known issue.
Thank you.
Community SupportHi Maverik91 ,
Thank you for reaching out to Microsoft Fabric Community.
When you define Row-Level Security (RLS) directly in the Report Server (via browser), it may not apply correctly. Microsoft recommends defining RLS roles in Power BI Desktop using the “Manage Roles” feature.Then, publish the report from Desktop to Power BI Report Server. Avoid editing RLS roles directly in the Report Server UI, especially with DirectQuery models. This ensures the roles are embedded properly and enforced as expected.
Please find the below Microsoft documentation for your reference:
Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn
Thank you.
Helper IIHi v-venuppu
Thank you for your response and for the documentation.
I'd like to clarify the exact procedure I am following, as I believe it points to a specific bug rather than a deviation from best practices. The workflow you described (creating roles in Desktop and then publishing) is what we generally do. The issue arises during subsequent edits.
Here is my exact workflow:
- I open the Power BI Report Server portal in the browser.
- I navigate to an existing report and select the option to "Edit in Power BI Desktop". This action opens the report in the Desktop application directly from the server.
- After making my changes in Power BI Desktop, I use the Save function, which saves the report directly back to the Report Server, overwriting the existing version. This is the integrated and recommended way to update reports.
- Following the save, I go to the report's settings in the web portal (Manage > Row-level security) and assign users to the appropriate roles. The interface shows everything is configured correctly.
The Problem: When I follow this specific "edit from server and save back" process, the RLS rules are not enforced at all. Users can see all the data.
The Workaround/Proof of Bug: If I then take that exact same report (which isn't working), download the .pbix file to my local machine, and immediately upload it back to the server, overwriting the report, the RLS starts working perfectly without any other changes.
This behavior leads me to conclude that this is a bug. The server fails to correctly apply the RLS policies when a report is saved directly from Power BI Desktop via the "Edit from Server" feature. However, the manual upload process correctly triggers the security application.
I hope this clarification helps to better define the issue.
Best regards,
- v-venuppu
Hi Maverik91 ,
You are absolutely right: the behavior you are seeing is consistent with a known limitation in Power BI Report Server. When you use the "Edit in Power BI Desktop" feature directly from the Report Server portal and then save back to the server, the RLS roles may not be properly embedded or refreshed in the report metadata - even though the UI shows them as configured.
To ensure RLS works correctly on Power BI Report Server(Until the issue got fixed):Recommended Workaround is as follows:
Download the .pbix file manually from the Report Server.
Edit it in Power BI Desktop (not via “Edit in Power BI Desktop” from the portal).
Save locally, then upload manually back to the Report Server.This manual upload correctly triggers RLS enforcement, unlike the “Edit from Server and Save” method, which may skip refreshing RLS bindings due to a known issue.
Thank you.