web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Two data sources in th...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Two data sources in the same reporting service ssrs

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at

    Hi,

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

  • Community Member Profile Picture
    Community Member on at

    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

    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 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 43 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans