Cannot use Quick Insights in a Data Model with RLS Roles

yousseftb — Sat, 09 May 2020 08:47:59 GMT

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.

Re: Cannot use Quick Insights in a Data Model with RLS Roles

d_gosbell — Sun, 10 May 2020 22:34:40 GMT

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-insights-in-a-data-model-with-rls 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.

topic Cannot use Quick Insights in a Data Model with RLS Roles in Report Server

Cannot use Quick Insights in a Data Model with RLS Roles

Re: Cannot use Quick Insights in a Data Model with RLS Roles