Key Influencer Visual Not Working

[Anonymous]

Whenever I try to use the Key Influencer visual in Power BI Desktop I recieve this message:

"Couldn't load the data for this visual

Can't display the visual.

<pi>Query (32, 3) Failed to resolve name 'AI.SAMPLESTRATIFIED'. It is not a valid table, variable, or function name.</pi>"

The visual works in Power BI Service but does not work in Power BI Desktop, March 2019 update.

Spoiler

[Anonymous]

@Anonymous ,

I am unable to reproduce this issue in Power BI Desktop March release(2.67.5404.801). Could you please share sample data of your table here? I will test it on my side.


Regards,
Lydia

[Anonymous]

[Anonymous]

@Anonymous,

Could you please copy and paste the data to excel, then share the excel file here?

Regards,
Lydia

[Anonymous]

I can't figure out how to attach a file to this comment so here's a link: Link to File

[Anonymous]

@Anonymous ,

What field do you use to create the visual? Do you have any measures/calculated columns/table named AI.SAMPLESTRATIFIED?

Regards,
Lydia

[Anonymous]

In the Analyze bucket: "Inspection Result"

In the Explain by bucket: "Inspection Year", "City", "Short Description", "Business Category", "Violation Category"

[Anonymous]

Additionally, no measures/calculated columns/tables named AI.SAMPLESTRATIFIED

[mmishal001]

It gives me an error when I embed the report on Sharepoint with the Key influencer visual

Wondering if have you come across this issue before and any potential workarounds?