Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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 |
|---|---|
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 |