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.
Hi friend,
Could anyone please kindly help me to set RLS for this user?
He is in charge of Thailand region which allows him able to see all products sold in ThaiLand. Meantime, He has additional role in charge of Product Candy which allows him to see performance of candy at all region.
Any help is high appreciated.
Solved! Go to Solution.
Hi @tracytran91
try this
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @tracytran91
try this
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
@v-xiaotang Thank for your solution.
I would like to ask whether there is a dynamic way to make it work?
@tracytran91 , You can not use all. This what I have done. I create a table like this
Product | Product All |
A | A |
B | B |
C | C |
D | D |
A | All |
B | All |
C | All |
D | All |
I joined it product column and merged in power query(on product All) and removed all and got the products
The same need to be done for the region
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 |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |