Cannot create connection to data source. Couldnot load file or assembly 'Microsoft.AnalysisServices.AdmodClient,Version =18.2.6.0, Culture=Neutral,publickey token=89845dcd8080cc91 or one of its dependencies.

Question

I see an error attached while trying to run a report on SSDT 2017. I have the file "Microsoft.AnalysisServices.AdomdClient.dll" in C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.AnalysisServices.AdomdClient\v4.0_14.0.0.0__89845dcd8080cc91 folder. However the file version i have is 14.0.1.439.

I had SQL server 2019 installed earlier but had to uninstall it and reinstalled 2017 community version. Is this the reason for this error? If yes, how can this be fixed? Any suggestions?

Answer 1

Edit the datasource to see if a valid & existing AdoMD data provider is selected.

Answer 2

Hi @Azhar ，
This seems to be more related to the SSAS profession, and it is difficult to see what the source of the problem is in SSRS. But when I was researching, I saw an article, as Olaf said, did you choose a valid and existing AdoMD data provider? You could refer to this article: Error: Record operation could not be performed. Could not load file or assembly 'Microsoft.AnalysisService, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dc8080cc91' or one of its dependencies. The system cannot find the file specified.
Obviously the relevant download links provided in this article are out of date for the version you are using, but this does not affect our exploration of this issue.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.