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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Dynamics 365 CRM FetchXML Reporting

(0) ShareShare
ReportReport
Posted on by 522

Hi,

I am not able to connect to Dynamics 365  CRM online from Sql server data tools Report Wizard.Please suggest

1425.Err1.png

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    gdas Profile Picture
    50,091 Moderator on at

    Hi Megha,

    Could you please validate with below reference  -

    docs.microsoft.com/.../create-a-new-report-using-sql-server-data-tools

    Make sure you are using compatible version  of data tools  and VS  . In addition also check you are using correct connection string.

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    33,628 on at

    Hi,

    do you have multiple organization in same account ?

    If yes,you need to specify organization unique id along with CRM online URL.

    You can get the unique id under developer resources

    Example: http://----.crm5.dynamics.com;org2beffc

  • megha18 Profile Picture
    522 on at

    Hi Wei Jie Fun,

    It has 1 org only.

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    33,628 on at

    Hi,

    try the suggestion from another post.

    1.) community.dynamics.com/.../232121

    2.) change your connection string, 

  • megha18 Profile Picture
    522 on at

    Hi,

    Changed the conn string still not working.

    Version: 

    4617.Err2.png

  • megha18 Profile Picture
    522 on at

       

    Hi Goutam,

        VS 2015 is installed,SSDT comes with it.Please check the details of report extension which is installed in system.

    2337.Err2.png

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    33,628 on at

    Hi,

    try update the reporting extension. The latest version is 8.2.2.248

    www.microsoft.com/.../details.aspx

  • gdas Profile Picture
    50,091 Moderator on at

    Could you please share the error now which you are getting.

  • megha18 Profile Picture
    522 on at

    Ok so do I have to uninstall the previous one?

  • megha18 Profile Picture
    522 on at

    Same error

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…

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