Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
I've recently begun to have issues with reports with RLS not letting me 'Test as role'. It used to work fine but all of a sudden I've started to get this 'Permission required' message coming up. I'm a workspace admin, the dataset owner, a pro user, and have access to the app for these reports so there is no reason why Power BI Service has suddenly decided I no longer have permissions for the underlying dataset. Once I close that error window I just get the fabric load icon with the progress bar stuck at around 30% and none of the links on the page work when clicked. I have to reload the page to do anything.
I deleted and republished one of the reports earlier in the week and it let me 'Test as roles' again only for the 'Permission required' message to start appearing this afternoon when I've attempted to 'Test as role'. I've even tried adding myself again on the dataset Manage Permissions page to no effect. This is affecting several reports which sit in their own workspaces but not all of them for some reason.
I'd prefer to not have to delete and republish reports on a weekly basis in order to be able to test row level security is working as expected in Power BI service. Has anyone else had this issue and found a solution? I've checked the 'Get Help' guidance and none of that helps.
Solved! Go to Solution.
I managed to resolve it by publishing additional test report (live connected to the same data model with RLS that I want to test in the first place) to the same workspace and that fixed the issue for some reason.
I managed to resolve it by publishing additional test report (live connected to the same data model with RLS that I want to test in the first place) to the same workspace and that fixed the issue for some reason.
It worked thank you!
Absolutely nonsensical but I'll take it 🙂
I'll give a that a go and see what happens 👍
I'm also having this issue. But not on all rls datasets. Works in other workspaces. I had synced this workspace with GIT, took that off, but no change. I have workspace admin, so all permissions. The service seems to lock up afterwards too. If you refresh the browser, it comes up with the RLS "View As" menu, with a blank page below.
I started having exactly the same issue. Any findings what is the reson or how to fix it?
Got a related community post
This is not a solved one but there are a few suggestions there to try
Regards,
Ritesh
Hi Ritesh,
Unfortunately that doesn't help.
I've got all the possible access rights I could have and created these workspaces. I presume it's a bug with Power BI itself since no changes have been made to the report but it suddenly stopped letting me test roles.
Kind Regards,
David
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
17 | |
16 | |
8 |
User | Count |
---|---|
49 | |
39 | |
32 | |
16 | |
14 |