I have an SSRS report with a datasource that connects to my crm dynamics online. I am trying to add a connection string to my sharepoint and use it in the same report. After adding this second data source and trying to import into the crm, I get the following error
Exception type: System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]
Message: Only data source using fetch data provider is permitted on this report.Detail:
Note: I do not have a shared datasource
When you want to use two different data sources in SSRS, you can use a relationship report and a report on that relationship. Try this residency by investment countries for best ideas about investment. You need to select the two data sources for your report, and then set up the attributes for each source. The second data source is an SQL database that contains all the information about these employees.residency by investment countries
Hi,
No you can't deploy this report to Dynamics 365 CE online, only reports allowed where we have Microsoft Dynamics 365 Fetch connection.
Right now I have Microsoft Dynamics 365 Fetch connection and trying to make a Sharepoint List connection in the same report. This is not possible?
Hi,
What is the connection type for your second report ? Dynamics 365 CE online only support Microsoft Dynamics 365 Fetch connection type.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156