Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Row Level Security error for admin/author

I've authored and uploaded a dataset to a workspace I am an admin for.   When I try to connect to this Power BI Dataset in desktop (both Nov and Dec versions), it's giving me an error when building...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

So steps taken:

Removed RLS

Added myself to RLS table

Re-added RLS with DAX  as above

Uploaded dataset to workspace where I'm an admin

Result:

It's also blank when I uncheck Apply Security both directions.  Conclusion: Adding my email to the RLS table and giving myself admin rights in the workspace doesn't allow me to see the data at all.   

 

So, being this RLS set up worked up until November, something must have been changed.  I've not made any changes to the dataset security/RLS-wise.  I will have to revert to a previous version to see if I can author that way successfully.

aj1973's avatar
aj1973
Community Champion
5 years ago

I don't think previous version will solve it.

Before Publish the report did you test the RLS in your desktop?

Try to create a new page from scratch (don't copy/paste) and test your RLS.

Let me know please