Reporting Services exception logged when calling Extensions rest api

Question

Whenever a user calls the "Reports/api/v2.0/Extensions" GET method of reporting services Rest API, the following error is logged in the ReportingServicesService log file:

library!ReportServer_0-1!472c!03/28/2023-09:32:14:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Unable to load assembly Microsoft.ReportingServices.Cloud.DataExtensions, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions' or one of its dependencies. The system cannot find the file specified. at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) at System.Reflection.Assembly.Load(String assemblyString) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.LoadAssembly(String name) --- End of inner exception stack trace ---;extensionfactory!ReportServer_0-1!472c!03/28/2023-09:32:14:: e ERROR: Exception caught instantiating DAX report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions' or one of its dependencies. The system cannot find the file specified.

And I checked my "C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\rsreportserver.config", there's no DAX extension at all, so I was wondering what it's instantiating DAX report server extension and how can I remove it or how to get rid of this error log

Thanks in advance.

Answer 1

Hi @Michael He

I'm sorry I couldn't revert your error, I tested this command and it worked. According to your logs, the error should be "Unable to load assembly Microsoft.Reporting Services.Cloud.DataExtensions", but I can't find the same file in my SSRS file. You may need to locate the assembly and put it where SSRS can find it. I found links with you with a similar error, you can use as a reference:

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=79e6180c-7189-4313-a3a4-d015f53b5a7f&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

https://community.powerbi.com/t5/Report-Server/Subscription-Failures-Unable-to-load-assembly/m-p/711946

Hope these can help you.

Best regards,

Aniya

Answer 2

Hello,

is there any solution for this issue:

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions