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.
@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.Regards,Lydia
@chrisl,Could you please copy and paste the data to excel, then share the excel file here?Regards,Lydia
I can't figure out how to attach a file to this comment so here's a link: Link to File
@chrisl ,What field do you use to create the visual? Do you have any measures/calculated columns/table named AI.SAMPLESTRATIFIED?Regards,Lydia
In the Analyze bucket: "Inspection Result"
In the Explain by bucket: "Inspection Year", "City", "Short Description", "Business Category", "Violation Category"
Additionally, no measures/calculated columns/tables named AI.SAMPLESTRATIFIED