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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Getting error while connecting SSRS report to Dynamics data

(0) ShareShare
ReportReport
Posted on by 10

Hello All,

I want to update one of my existing SSRS report created for Dynamics. This report was developed before 4 years.

To make it simple I created a new solution and tried to create a new report. Here the system ask me to provide the connection string where I provide below url-

disco.crm.dynamics.com/;<<OrgID>>               (In the above url I have replaced the OrgID with my Org unique Id. )

after clicking Next it shows a form to mention deployment type and other details where I am adding the dynamics user details.

after adding above details it is showing me the connection error.

pastedimage1668606069579v1.png

Note: I have installed the latest version of Dynamics Report authoring extension. previously I was having the older version after which I uninstall and reinstall it. in this process I also clean the keys from the registry. still I am getting the same error while establishing the connection.

Any help would be highly appreciated.

Regards

Shruti Vyas 

I have the same question (0)
  • Suggested answer
    Steve Zhao2 Profile Picture
    Microsoft Employee on at

    Hi ShrutiVyas,

    You should type your organization url here:

    pastedimage1668673331605v1.png

    You could find your organization url at PPAC->Environments->Your environment:

    pastedimage1668673473461v4.png

  • ShrutiVyas Profile Picture
    10 on at

    Thanks Steve for your reply.

    I tried with Organization URL but still getting the same error.

  • Steve Zhao2 Profile Picture
    Microsoft Employee on at

    Hi ShrutiVyas,

    Which option you select in Credentials? If you select name and password, please check it.

  • ShrutiVyas Profile Picture
    10 on at

    I have selected Prompt for Credentials options. It ask me the credentials and after providing the credentials it shows below screen-

    pastedimage1669014781151v1.png

    In the above screen I am providing user name and password and after clicking on Login it is showing below error-

    pastedimage1669015066138v1.png

    I am stuck here.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
NeerajPawar Profile Picture

NeerajPawar 31

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 19 Super User 2026 Season 1

#3
11manish Profile Picture

11manish 18

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans