Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |