Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am working with a dataset where Row-Level Security (RLS) is implemented, and we have multiple thin reports. We now have a requirement for one of these thin reports to display global numbers, effectively overriding the RLS implementation.
My current solution involves creating duplicate tables (both dimension and fact tables) specifically for this report to bypass RLS. However, this approach leads to having multiple fact tables with millions of rows, which significantly increases the dataset size and computational overhead.
Is there a more optimal way to achieve this without duplicating large fact tables? Any suggestions or best practices would be greatly appreciated.
My dax to filter the dataset looks like this.
Is there a more optimal way to achieve this without duplicating large fact tables?
Not really. Consider using separate reports/audiences. But the data duplication is required.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |