Unable to test row level security in Power BI Service - Permission Required

[david_busint]

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. 

[Domantas_G · Accepted 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. 

[david_busint]

It worked thank you!

Absolutely nonsensical but I'll take it 🙂

[david_busint]

I'll give a that a go and see what happens 👍

[RichieRichAzj]

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.

[Domantas_G]

I started having exactly the same issue. Any findings what is the reson or how to fix it?

[ribisht17]

hi @david_busint 

Got a related community post

https://community.fabric.microsoft.com/t5/Service/Cannot-see-the-content-of-this-report-because-you-...

This is not a solved one but there are a few suggestions there to  try

Regards,

Ritesh

[david_busint]

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