Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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 |
---|---|
6 | |
4 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
3 | |
3 | |
2 | |
2 |