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 / Microsoft Dynamics CRM (Archived) / Visual Studio report d...
Microsoft Dynamics CRM (Archived)

Visual Studio report designer unable to connect to CRM data source

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All
I’m trying to edit an SSRS FetchXML report in Visual Studio 2015, connecting to Dynamics 365 Online v9.1.

I can preview the report fine in VS so the data source connection works, but when I go to Query Designer for the report dataset I get ‘Unable to connect to data source’.

Setup:

  • Visual Studio Enterprise 2015 Update 3
  • Dynamics 365 Developer Toolkit version 1.3.2000.9032
  • SQL Server Data Tools for VS2015 version 14.0.61712.50
  • Dynamics 365 Report Authoring extension version 9.0.2.426

I’ve tried using TLS1.2 and the SchUseStrongCrypto regedit, both mentioned elsewhere on this forum, but still get the error. I’ve also tried uninstalling VS2015, SSDT & Report Authoring and then reinstalling, same issue.

Does anyone have any suggestions?

Many thanks

Steve

*This post is locked for comments

I have the same question (0)
  • Kokulan Profile Picture
    Kokulan 18,054 on at

    The fact that Preview works for confirms your connection is working. The query designer may not be connecting to CRM using the same way as the preview screen.

    I would first restart VS or restart the machine itself and run VS in admin mode and see if it connects.

  • Community Member Profile Picture
    Community Member on at

    Thanks, I have tried restarting VS and the machine, and running in admin mode but the problem persists.

  • Jarrod Williams Profile Picture
    Jarrod Williams 1,747 on at

    To my knowledge the Query Designer isn't going to be able to generate or modify the FetchXML for you for your data sets.  Closest you are going to be able to get for generating fetch would be to create an advanced find that is giving you the sort of guidelines you are using and then download that FetchXML string.  

    If you are getting the error when you select the data set and go to properties please update with a screenshot of the error.

  • Community Member Profile Picture
    Community Member on at

    Thanks. I get the error when I try to open the query for the dataset with Query Designer. It is a FetchXML query but I'm not trying to generate any FetchXML. Screenshot attached...

    screen-2019_2D00_03_2D00_07.jpg

  • Suggested answer
    Kokulan Profile Picture
    Kokulan 18,054 on at

    If it is something you could try, i would uninstall the Dynamics 365 Developer Toolkit, and try and see if it resolves the issue. Its a not a permanent solution but i  did have some issue with Report Authethering extension and developer toolkit.

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 > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans