Forum Discussion

SeniorJunior's avatar
SeniorJunior
Frequent Visitor
1 year ago
Solved

RLS issues

Hi all,    I have an exising report that has recently moved workspaces and adding new people to the RLS doesn't seem to be working for them.    I have a spreadsheet with their name, email and per...
Need Help
  • SeniorJunior's avatar
    SeniorJunior
    1 year ago

    Thanks for your offer of help. I re-checked everything yesterday, double checked all the various things we've discussed and then opted to republish the report (same name, etc) and update the app again. 

     

    For some reason it is now working, which is great news, as I was running out of options! 

     

    Sadly this won't be much help for anyone else finding this thread on the search feature, but hopefully between the two responses I've had there's a good checklist for people to work through. 

     

    Thanks again for your kind assistance. 

SeniorJunior's avatar
SeniorJunior
Frequent Visitor
1 year ago

Joe_Barry  Thanks for you response.

 

So, the roles are set up in an Excel file which is then linked into the report similar to this: Dynamic Row Level Security with Power BI Made Simple - RADACAD with the table filtering, DAX, etc all very similar and had been working fine until recently for these new users.  

 

I manage the Excel, so know that there's no spaces at the end of the columns, drop down list for roles so there can be no typos. 

 

Company is a PPU with everyone on it. 

 

They can see the report but get a message that permissions are denied as they don't have access to the underlying dataset (that uses RLS).

Joe_Barry's avatar
Joe_Barry
Solution Sage
1 year ago

Good morning SeniorJunior 

It seems that you have everything correct. How is the relationship built between the Spreadsheet and the FACT Table? Email to Email?

If it's possible can you send me a screenshot of the relationships with a clear view of what columns are being used. Also a screnshot of the Roles under the Modeling tab and the DAX formula for that?

 

Thanks

 

  • SeniorJunior's avatar
    SeniorJunior
    Frequent Visitor
    1 year ago

    Thanks for your offer of help. I re-checked everything yesterday, double checked all the various things we've discussed and then opted to republish the report (same name, etc) and update the app again. 

     

    For some reason it is now working, which is great news, as I was running out of options! 

     

    Sadly this won't be much help for anyone else finding this thread on the search feature, but hopefully between the two responses I've had there's a good checklist for people to work through. 

     

    Thanks again for your kind assistance. 

    • Joe_Barry's avatar
      Joe_Barry
      Solution Sage
      1 year ago

      The main thing, is that the issue is resolved for you.

       

      All the best

      Joe