The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Cannot use Quick Insights in a Data Model with RLS Roles
I have a Data Model with 2 Roles setup for Row Level Security (RLS). When I load it to the Service, Quick Insights is not available. If I remove the roles and re-upload the file, then Quick Insights is automatically enabled.
I'm pretty sure this is a limitation with the Quick Insights feature, there is an idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15631218-cannot-use-quick-insight... to enable quick insights for models with RLS.
From what I understand they generate the insights by running a bunch of machine learning (ML) models against your data set. The issue with RLS is that they would have to run a different pass of the ML models for every possible combination of RLS roles otherwise they would risk exposing information in the insights that a given user is not allowed to see.
User | Count |
---|---|
4 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
4 | |
4 | |
4 | |
3 | |
2 |