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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      So reverting to September version still creates the issue.  I think it means basically, I can't apply the security in both directions.  

    • 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