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,
I have two tables and I need one to filter the other but i tried several methods and it doesn't work for apply my dynamic RLS.
I have already filter the list of CODE_CP (in tec_tab_regroupement) by the user email.
I need the list in the table Tec_Tab_Regroupement[CODE_CP] to filter a more complete list in the table Tec_bridge_Ref[CODE_CP].
Thanks for your help
Guillaume
Solved! Go to Solution.
Hi , @Guillaume_S
According to your description, you want ro set the RLS in another column with the dynamic RLS. RIght?
After you have set up dynamic RLS, you can create another role and set the RLS of the table Tec_bridge_Ref [CODE_CP], like this:
Then we can test in Power BI Desktop:
The result is as follows:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @Guillaume_S
According to your description, you want ro set the RLS in another column with the dynamic RLS. RIght?
After you have set up dynamic RLS, you can create another role and set the RLS of the table Tec_bridge_Ref [CODE_CP], like this:
Then we can test in Power BI Desktop:
The result is as follows:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |