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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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