Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
daamruth
Helper II
Helper II

AI Features like Explain increase missing with row level security

Hi all, 

 

is it correct (and where can I find documentation) that the AI features are not availbale to anyone on a data set as soon as I setup row level security? If yes, this is really worth an idea (Some know of an existing one?) because this was one of the features why we decided on Power BI. 

 

Thanks

Daniel 

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Please kindly note the limitation:

Insights doesn't work with DirectQuery, streaming, and PUSH datasets; it only works with data uploaded to Power BI.

Row-level security (RLS) isn't supported by quick insights, even in import mode.

Vlianlmsft_0-1624429755544.png

The failure of this feature will also result in the failure of the analyze feature.

View solution in original post

12 REPLIES 12
V-lianl-msft
Community Support
Community Support

Please kindly note the limitation:

Insights doesn't work with DirectQuery, streaming, and PUSH datasets; it only works with data uploaded to Power BI.

Row-level security (RLS) isn't supported by quick insights, even in import mode.

Vlianlmsft_0-1624429755544.png

The failure of this feature will also result in the failure of the analyze feature.

Thanks @V-lianl-msft , 

 

that is a pitty. Do you know of any idea I could push or any alternative? (Mutiple Datasets is no option, sorry 🙂

 

Thanks

Daniel 

You could submit or vote for this idea to bring the feature coming soon

 

daamruth
Helper II
Helper II

Hi @aj1973 , 

 

thanks for your answer. What I meant is rather this feature: 

 

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-analyze-visuals

 

Sorry for that. It used to work but after setting the RLS it no longer does. 

And we have Premium per User atm. 

Can you confirm that? 

 

Thanks

Daniel 

aj1973
Community Champion
Community Champion

Hi @daamruth 

Ok AI is not RLS.

RLS is applied for Power Bi Users, the feature you are talking about is for Power Bi Consumers

aj1973_0-1624284588121.png

 

Now

aj1973_1-1624284675362.png

 

If you have a PPU license then you are not a Power bi consumer. If the Consumer has a free License then he can't see the report with RLS implemented.

 

Hoep it is clear and confirmed.

 

 

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hi Amine, 

 

perhaps I wasn't clear on my topic. Let me try to explain: 

 

I have a Data Model without RLS. Inside of that the "Analyze"-function work properly. When I click on a timeline I can choose "Analyze" --> "Explain increase". 

 

I then added RLS to the model. Since then the option is no longer available - on the exactly same visual. 

Is that a bug? 

 

Thanks

Daniel 

aj1973
Community Champion
Community Champion

There is no bug,

Do your users that you have added them to the RLS have a Pro license?

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

I am testing with myself: Power BI Premium per User license. 

aj1973
Community Champion
Community Champion

And that's exactly what I have been explaining to you. A PPU can not use Analyze feature. Only a free user can.

Did you read and analyze the 2 images i sent you previously?

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hi @aj1973 ,

 

thanks for your answer. This makes no sense to me. You want to say that people with pro and premium licenses have less features than a user with a free version (on premium capacity)?! 

 

Why was it availbale before i set the RLS? 

 

I rather think it is because of Power BI not supporting it when RLS is enabled. Same applies to Quick Insights: https://community.powerbi.com/t5/Service/Quick-Insights-greyed-out/m-p/1466208 and also found here

daamruth_0-1624387781212.png

 

Thanks for your help though.

 

Once again the features look great until you really try to make use of them.

 

Cheers

Daniel 

 

 

 

aj1973
Community Champion
Community Champion

Hi @daamruth 

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

Connect to AI Insights in Power BI Desktop - Power BI | Microsoft Docs

The only limitation I see implementing RLS is when connecting with DQ mode. AI 

aj1973_0-1624102669614.png

Know though, you need Premium license to use AI in Power bi.

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.