Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Two data sources in the same reporting service ssrs

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Two data sources in the same reporting service ssrs

    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

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: Two data sources in the same reporting service ssrs

    Hi,

    No you can't deploy this report to Dynamics 365 CE online, only reports allowed where we have Microsoft Dynamics 365 Fetch connection.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Two data sources in the same reporting service ssrs

    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?

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: Two data sources in the same reporting service ssrs

    Hi,

    What is the connection type for your second report ? Dynamics 365 CE online only support Microsoft Dynamics 365 Fetch connection type.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans