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.
Good afternoon,
I've read through the forums about using RLS and how it should the role should apply when you analyze in Excel. However, I've tried mulitiple times through a test role (as suggested in one forum), and my test role still gets all of the data. Please advise.
Thank you.
Solved! Go to Solution.
We have resolved the issue. I redownloaded Power BI Publisher for Excel. Then I reshared and redownloaded the report of my dashboard, and the RLS worked.
I test the scenario as yours, RLS works as expected when using Analyze in Excel. In your scenario, please ensure that you have added the user as role member in Power BI Service, then share dashboard to your user.
Regards,
Lydia Zhang
I have done all of these things. Just now, I removed my test role from all roles in Power BI service, added it back to one role that only has access to 3 pieces of data, shared the dashboard, then logged into the test role account, selected analyze in excel, and it gave me all the data again.
We have resolved the issue. I redownloaded Power BI Publisher for Excel. Then I reshared and redownloaded the report of my dashboard, and the RLS worked.
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.