cancel
Showing results for 
Search instead for 
Did you mean: 

Key Influencer Visual Not Working

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
 

 

 

Status: Needs Info
Comments
Moderator

@chrisl ,

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.
1.PNG

Regards,
Lydia

Moderator
Status changed to: Needs Info
 
Frequent Visitor

Screenshot of Restaurant Inspection Data.JPGScreenshot of Key Influencers Error.JPG

Moderator

@chrisl,

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

Regards,
Lydia

Frequent Visitor

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

Moderator

@chrisl ,

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

Regards,
Lydia

Frequent Visitor

In the Analyze bucket: "Inspection Result"

 

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

Frequent Visitor

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