Forum Discussion
Key Influencer Error..."Failed to Resolve Name 'AI.SAMPLESTRATIFIED'....
My colleague and I have a PowerBi report linked to a SQL query that was written in Visual Studio. The query feeding the datset examines sales between this year and last year by department, percent changes between this year and last year, and acategorical variable that says 'sales flat/increasing/decreasing' based on the percent change values.
When we went to the Key Influencers visual and used the categorical variable in the 'Analyze' section, and tried to add another variable in the 'Explain By', we get an error saying:
"Failed to resolve name 'AI.SAMPLESTRATIFIED'. It is not a valid table, variable, or function name."
This pops up regardless of the variable used. Has anyone else rain into this or a similar error?
15 Replies
Same issue here. I tried with a lot of different types of data and datasources, but always receive the same error message.
lisahua46Microsoft Employee
1. Can you try to double check the .Net version? I follow https://docs.microsoft.com/en-us/dotnet/framework/migration-guide/how-to-determine-which-versions-are-installed and do (Ctrl +X, A) to open PowerShell and copy ` (Get-ItemProperty "HKLM:SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full").Release`, I got 528040, matches .Net 4.8.https://docs.microsoft.com/en-us/dotnet/framework/migration-guide/how-to-determine-which-versions-are-installed#minimum-version
2. Open Assembly Binding Log Viewer in Windows by typing "fuslogvw" in Win Search, https://docs.microsoft.com/en-us/dotnet/framework/tools/fuslogvw-exe-assembly-binding-log-viewer
Delete all (clean), then open the PowerBI influencer visual, after that, click Refresh button in fuslogvw viewer, you should see missing dlls.
Thanks for your reply
My .Net version is 0x00080ea8 (528040)
Fuslogvw (started via Visual Studio 2019 Developer Command Prompt v16.3.4 as admin) was and remains (Power BI started as admin) empty.
Perhaps important: Adding a categorie in Analyze seems to work, No fields in "Explain by" is returned. After adding a field in "Explain by" the error occures.
