Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
i am currently searching for a solution to implement an Anti Join in BI with a user context & direct query. I tried a lot and did'nt find a solution.
The scenario is the following:
The data model is
So the requirement is that if one message is added to the ignore-list for a user, the user should not see the message in BI
I tried several solutions (e.g. the DAX Except statement and the Join Query function), but that doesn't worked.
My idea was to use dynamic M query parameters and call a function giving the user Principal Name as parameter, e.g.
let
Quelle = AzureDataExplorer.Contents("https://xxxx.westeurope.kusto.windows.net", "public", Text.Combine({"MyTable(""",PrincipalName,""")"}), [MaxRows=null, MaxSize=null, NoTruncate=null, AdditionalSetStatements=null])
in
Quelle
Since "USERPRINCIPALNAME()" cannot be used in an M-Query (Unfortunately!!!), I used the Parameter "PrincipalName" bound to a table containing all PrincipalNames, selected by Row Level Security using "USERPRINCIPALNAME()" as filter.
The solution works except one thing: The parameter "PrincipalName" is only set if a row in the RLS Table is manually selected by the user. The RLS functionality alone does not change the parameters value.
Is there anybody solved this in one or another way?
Thank you in advance,
Christian
Hi @Christian_Heinz ,
Believe that the best person to answer you to this one is @ImkeF best M language user in the community.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
73 | |
73 | |
39 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
51 | |
43 | |
42 |