i have developed a simple ProofOfConcept WinForms app that uses Microsoft.AnalysisServices.NetCore.retail.amd64 to interact with SSAS to refresh a PowerBI dataset. works fine
(using .netCore 3.0)
am now trying to do the same in a script task in SSIS so we can refresh the PowerBI datasets as final step of doing the overnight ETL
but the framework package for the c# script is .NetFramework 4.7 - so compatability issues with the DLL used above
is it possible to change this so i can use the same .netCore3.0 DLL that i used before... if so, how ??
i have also tried using Microsoft.AnalysisServices.retail.amd64 (implemented via a NuGet package) but it fails with
Error: Could not load file or assembly 'Microsoft.AnalysisServices.Tabular, Version=19.22.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
that should work but the c# script seems to delete the DLLs from where the NuGet package puts them.
environment is VisualStudio Enterprise v 16.9.4, targeting SQLServer 2019