Hi!
I need to deploy some SSRS reports that use my CRM Online data (Dynamics 365) to my local Reports Server. Everything works fine on BIDS and also if I deploy them to CRM. But I can't seem to be able to configure the MSCRMFETCH extension properly on my server for them to work locally too. I've read many things online but nothing really pointed in the right direction (other than maybe not being possible due to incompatibility).
I have added the extension to the server in the same way I have it configured on BIDS:
<Extension Name="MSCRMFETCH" Type="Microsoft.Crm.Reporting.DataExtensionShim.Client.Fetch.FetchExtConnection,Microsoft.Crm.Reporting.DataExtensionShim.Client.Fetch.Clr4" />
I have installed BIDS and the CRM Extension on my SSRS server. But when I try to run a report I just get a message saying:
- An error has occurred during report processing. (rsProcessingAborted)
- An attempt has been made to use a data extension 'MSCRMFETCH' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)
On the report server (I'm running SQL 12.0.5000.0 on the server) I can see the error below. I tried with different versions of the DLLs but I'm wondering if this is indeed a lost cause or if this is completely doable. Any ideas?
extensionfactory!ReportServer_0-2!1b7c!04/27/2019-08:54:52:: e ERROR: Exception caught instantiating MSCRMFETCH report server extension: System.BadImageFormatException: Could not load file or assembly 'Microsoft.Crm.Reporting.DataExtensionShim.Client.Fetch.Clr4' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.
File name: 'Microsoft.Crm.Reporting.DataExtensionShim.Client.Fetch.Clr4
Thanks!