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.
Hello,
For the axample i have two tables :
Relationship : Table1 1----N Table2
I have one role : RLS : [email] = USERPRINCIPALNAME()
I apply the role in the two tables.
When i display one column from Table2 in visualization i have this sql generated :
select column1 from
(Select * from Table2 where Table2.email ='toto@toto.com' ) test
INNER JOIN Table1 on test.key = Table1.key
WHERE Table1.email ='toto@toto.com'
I dont want powerbi to do the join with Table1.
I don't understand this behavior.
How to avoid it?
Best regards
Hi @hi_world
The join operation is caused by the relationship between two tables. And you have applied the RLS rule on both tables. Since the relationship exists, usually you only need to apply the RLS rule on one table that can filter the other table via the relationship. Try removing the RLS rule on Table1 or Table2. This may give you a different result.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hello @v-jingzhang
what would be your solution if you still have to apply the same role on both tables because both tables have RLS ?
Best regards
No, it is an important relationship
Hello @v-jingzhang
So you tell me that this is a normal behavior of powerbi.
the problem with this join generated by powerbi can cause a loss of information on certain rows of the tables. because of the where on the second table.
Thanks for your feedback
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.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |