I have a data model / report with a wide distribution list. Recently we experienced a critical error with our dynamic RLS setup. It has been working perfectly for months. We narrowed it down to Companies, who has not been properly registered in the Company master table, but somehow exist in our Security/ User Bridge. Please follow this illustration of the data model RLS filtering as user@user.com opens the Power BI App:
As you can see, user@user.com is logging into the Power BI app, and the User table is properly filtered down to only his username. The UserBridge is also correctly filtered, though the corresponding CompanyId in this table, doesn't find a match in the Company table. Thus the Company table throws a blank filter to the Service table, which again, at least it SHOULD propagate to the Billing table. However as you can see the billing table returns a few lines with blank ServiceId values, which is expected due to the omission of a CompanyID in the Company table (and the fact that the Billing table, while not intended, contains rows with blank ServiceIds), BUT it also returns a subset of seemingly random ServiceId lines. How this is even possible, is simply beyond my understanding of how RLS works in Power BI. I get the same test result offline in Power BI Desktop.
I have posted this as a question in the forums, but have not gotten any feedback, so I am starting to suspect that this is indeed a general issue/bug. Hopefully we can get to the bottom of this.
- MaAl on: "The import PowerPlatform.Dataflows matches no exp...
-
NikNithiy
on:
URGENT!! Paginated Report not loading on Mozilla F...
- duarte on: Unable to sort months in PowerBI
- adam_hfg on: Matrix Visual doesn't work with Field Parameters ...
-
mattlee
on:
“Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on:
Fix the Date function in DAX
-
Stinkys
on:
Cannot login to community site