Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report set up with RLS that was working perfectly fine until today. The report restricts access based on the brand that the user is associated with. Again, this was working perfectly and as expected. I did update the data today, but it was only a minor appending of a few days worth of data. Nothing that should affect this, but that's obviously still a possibility.
The annoying part with all of this is that the error is only for a single group (yellow highlight in snippet below). In addition to this, the report in Desktop works as expected. It is only in the Online Service that the issue occurs. Any ideas? I have already checked the underlying data to make sure that the Group restriction did not change when I updated the data. Everything looks correct (which explains why Desktop is working).
Been stuck at this for multiple days now so any help is greatly appreciated!
Solved! Go to Solution.
I figured out a workaround:
Not ideal but it works!
I figured out a workaround:
Not ideal but it works!
Hi @tficar
Can you check to see if this group of users was added to the App Workspace roles, which would allow the users to see all the data?
Thanks for replying @GilbertQ . I should have clarified more but the issue is that the user has no access to any brands, so their charts are blank. See below for a screenshot of what it looks like. You'll notice that Vitaburst is "selected" but it's just the previous value that was chosen before changing to the current user.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.