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 Everyone,
I am facing issue with Relationship /Merging /RLS.
Here is my issue i have some tables with mail ids and some tables with Data .
i need the RLS that need to apply to the reports along with Relationship of the tables .
i have tables like Maintable , Table A,Table B, TableC, TableD,TableE with interlinked connected but i need main table column Table E column into my report .Actually i am doing merging with one table linked with another table it is working fine
Country -->Maintable
State -->Maintable
Maintable-->TableA-->TableB-->TableC--->TableD--->TableE
Please check the screenshot for reference.
Please help me on this issue .
Is there any way to get that Relationships for Multiple Data sets /Tables along with Multiple tables RLS without Merging because when i do merging with all related columns from one table with another table it is working fine with less number of rows (less than 1000 rows).
when it come to more rows refreshing with new data getting issues like Timeout error or Memory out of space or VM hangout.
Note : Output is to get Report 1 and Report 2 from all the tables
Thanks in Advance
Sandeep
Your data model is complex, here I will show you some blogs about dynamic rls and I hope they could help you.
Blogs:
Dynamic Row Level Security in Power BI
USING DYNAMIC ROW-LEVEL SECURITY WITH ORGANIZATIONAL HIERARCHIES
If this reply still couldn't help you solve your problem, please share a sample with me.
Best Regards,
Rico Zhou
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 |
---|---|
113 | |
100 | |
77 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |