Not getting Analyze option on Visuals in PBI reports.

[DipaliAnsarwade]

Issue:

Unable to see Analyze option on Visuals when I right clicked on charts (tried bar and line chart)

Background:

I have one Dataset File where we have fetched data from tables and views. Even all the measures and Inline tables are created in Dataset file only. And then we are using this dataset file as a source of PBI report File. All it means we use live connection using published dataset.

Can you please help me to conclude on Analyze feature limitation. as i can find Analyze option when i was fetched data from direct tables or view in PBI report. but not when we are fecting data from Dataset file.

Thanks in Advance

[pratyashasamal]

@DipaliAnsarwade  Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[DipaliAnsarwade]

Hi @pratyashasamal  As per our analysis, reason behind that is we have RLS enabled data model that's why not getting analyze feature in reports. 

Getting Analyze feature withount RLS :

Not getting Analyze option with RLS:

Could you please elaborate on why this RLS is limitation to see Analyze option and Any workaround on this?

[pratyashasamal]

Hi @DipaliAnsarwade ,
This is a limitation of Analyze feature in Power BI . And there no workaround for this right now.
I would suggest to submit a idea request with Power bi regading this.
https://ideas.fabric.microsoft.com/
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[pratyashasamal]

Hi @DipaliAnsarwade ,

The Analyze feature isn't available for all visual types.

The following list is the collection of currently unsupported scenarios for the Analyze feature (Explain the increase, Explain the decrease, Find where the distribution is different):

• TopN filters
• Include or exclude filters.
• Measure filters
• Non-numeric measures
• Use of "Show value as."
• Filtered measures. Filtered measures are visual level calculations with a specific filter applied (for example, Total Sales for France) and are used on some of the visuals created by the insights feature.
• Categorical columns on X-axis unless it defines a sort by column that is scalar. If using a hierarchy, then every column in the active hierarchy has to match this condition.
• RLS or OLS enabled data models.

You can find all details in this link :-
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-analyze-visuals

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C