Forum Discussion
RLS issues
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.
Hi SeniorJunior
What is the licensing situation at your company? Premium or each reader has a Pro Licence? If it's premium, it could be the report isn't in a Premium Workspace or if it's Pro Licences, maybe the users need a licence?
When you mention permission, do you mean that they can see the report, but RLS is preventing them from viewing it?
You never mentioned anything about how your RLS is set up. In the report how are the roles created? Is the spreadsheet built into the report also? How is the Relationship setup between the Spreadsheet and the Fact table you are filtering? Maybe there is some spaces at the end of the email address in the spreadsheet?
Can you provide some more information on this? Maybe I can help further
Joe
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).
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
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.
The main thing, is that the issue is resolved for you.
All the best
Joe