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.
We have implemented row-level security in a dashboard.
The tables are working fine, but when we publish the dashboard in Report Server the row-level security does not work.
I created a measure just for testing User = userprincipalname() and I saw that the function does not return the user, but instead the Server Name. The function works fine when editing .pbix file.
Also the Row Revel Security in Manage is greyed out and I can not click.
Solved! Go to Solution.
@FarhanAhmed Thank You for your answer.
I managed to fix the issue for the row level security by checking the tickbox Log in using these credentials, but then try to impersonate the user viewing the report in Manage -> Data sources the Report Server.
Now the function shows the user that is viewing the dashboard.
Hi,
Can you please share the screenshot of the issue?
Also, make sure that you have roles created under Manage Roles
Proud to be a Super User!
@FarhanAhmed Thank You for your answer.
I managed to fix the issue for the row level security by checking the tickbox Log in using these credentials, but then try to impersonate the user viewing the report in Manage -> Data sources the Report Server.
Now the function shows the user that is viewing the dashboard.
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 |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |