Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Key Influencer Visual Not Working

Submitted by Anonymous on ‎03-20-2019 09:06 AM

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
See more ideas labeled with:
9 Comments (9 New)
Comments
Anonymous
Not applicable
‎03-20-2019 11:50 PM

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

Regards,
Lydia

Anonymous
Not applicable
‎03-20-2019 11:50 PM
 
Anonymous
Not applicable
‎03-21-2019 08:55 AM

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

Anonymous
Not applicable
‎03-22-2019 02:13 AM

@Anonymous,

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

Regards,
Lydia

Anonymous
Not applicable
‎03-22-2019 09:22 AM

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

Anonymous
Not applicable
‎03-27-2019 02:40 AM

@Anonymous ,

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

Regards,
Lydia

Anonymous
Not applicable
‎03-27-2019 08:57 AM

In the Analyze bucket: "Inspection Result"

 

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

Anonymous
Not applicable
‎03-28-2019 04:11 PM

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

mmishal001
Frequent Visitor
‎05-02-2021 02:38 AM

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?

mmishal001_0-1619948322177.png

 

Idea Statuses