Forum Discussion
Row Level Security error for admin/author
So this is a bug. It's not going to be fixed until Mid-March. There is a workaround that doesn't last long where you have to open the dataset in the powerbi service and then connect to it via the desktop to create your reports. Last a few hours then stops. Absolute madness this has been like this since November. Five months for a fix so I can do my job. Well done Microsoft.
So this is a bug. It's not going to be fixed until Mid-March. There is a workaround that doesn't last long where you have to open the dataset in the powerbi service and then connect to it via the desktop to create your reports. Last a few hours then stops. Absolute madness this has been like this since November. Five months for a fix so I can do my job. Well done Microsoft.
Hi,
I was having the exact same issue.
The formula for configuring RLS in PBI desktop is the following
And I've also made a 'no RLS' group:
And had checked the Both ways security checkbox.
Also, when connecting to the published dataset from desktop, still was not able to see any data.
What fixed the problem for me was
- Deleting the dataset from the workspace
- Unchecking, and checking back in the both way security option
- Publishing the dataset back to the workspace
If I did it by overwriting an already existing dataset, then it did not solve anything.
Maybe this could also work for you or anyone else experiencing this bug.
I can't delete my dataset. It is the only one we have for all our reports sof we remove it we remove all our reports and we have lots of them. I thought that was the whole point of this.....you should keep your datasets to a minimum and author all your desktop reports off of one. It just means writing reports takes way longer than it should and hasecome annoying. It's a major fail on their part and they aren't even mentioning it in the current support issues.