Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is there any way to optimize or tweak indexes of a dataset? We want to tune it a bit for faster performance with RLS.
Solved! Go to Solution.
No, not like you can with an index for a table in a relational database. There are best practices for creating optimal fields to filter on. For example, using RLS to filter based on integers will be a little faster than text, but much better than large text fields, like GUIDs or anything over 20chars or so, because of the large data dictionaries produced.
Having a good star schema with narrow fact tables help too. Better compression, faster speed. To really dig in, chatpers 17 & 18 of the Definitive Guide to DAX will explain how the vertipaq enigine works, and what works well and what doesn't. So you won't optimize for RLS specifically, you will optimize the overall model, and RLS performance will benefit
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingNo, not like you can with an index for a table in a relational database. There are best practices for creating optimal fields to filter on. For example, using RLS to filter based on integers will be a little faster than text, but much better than large text fields, like GUIDs or anything over 20chars or so, because of the large data dictionaries produced.
Having a good star schema with narrow fact tables help too. Better compression, faster speed. To really dig in, chatpers 17 & 18 of the Definitive Guide to DAX will explain how the vertipaq enigine works, and what works well and what doesn't. So you won't optimize for RLS specifically, you will optimize the overall model, and RLS performance will benefit
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting