Microsoft Dynamics CRM (Archived)

SSRS using Microsoft Dynamics 365 Fetch as DataSource

(0) Share

Report

Posted on by FikriHailal

115

Hi, i just want to create SSRS project using Dynamics 365 Fetch as SataSource. I have installed:

- Visual Studio 2013

- BIDS for Visual Studio 2013

- Microsoft Dynamics 365 Report Authoring Extension

And this what i have tried:

1. Create a connection string:

https://mito.crm5.dynamics.com; my org unique name

458102.1.png

2. Specified Credentials

830418.2.png

The result tell me that my credentials was wrong. But when i tried to login into CRM Online using those credentials, everything was fine.

51804.3.png

What was wrong with my step above ?

*This post is locked for comments

All responses (12)

Answers (0)

agaliano1 5 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource

Hi David,

where would I find the credential cache location?
David Jennaway 14,063 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource

I normally use the url to the Organization.svc , which you get from the developer resources, and I've never had problems with that.

Do you use different credentials to connect to different organisations ? If so, I find that VS doesn't cope well if you have cached credentials. Normally the symptom is that you can get prompted to connect multiple times, but it may be that you have some incorrect credentials cached, and it is using these. Try clearing the credential cache on the machine (or running VS as a different user with no cached credentials)
Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource

Hi,

https://mito.crm5.dynamics.com; my org unique name <--- changed into https://mito.crm5.dynamics.com/ my org unique name

I just tested in my environment, everything is working as expected.

I also recommend you try to install visual studio 2015 and give a try.

If in the end , nothing is working, contact Microsoft support would be the best idea.
Suggested answer

Jharana Baliyar Singh 2,665 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource

Hello,

Please have a look in to below url :

community.dynamics.com/.../244891

social.msdn.microsoft.com/.../crm-2011-online-bids-unable-to-connect-to-data-source-crm-onlinethe-connection-to-server

And also check with the latest reporting extension, visual studio version .

Thanks,

Jharana
FikriHailal 115 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource

Any idea ? anyone
FikriHailal 115 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource
Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource

Hi,

can you go to Setting > Customization > Developer Resources? Get your organization name like below picture.
FikriHailal 115 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource

Hi, i was used the org unique name. In my crm organization. The org unique name showed as a number like org unique id but without "-".

I.E : if org unique id is : 708ac-0812bc-8181 then my org unique name is: 708ac0812bc8181.
FikriHailal 115 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource

Hi Fun Wei Jie, i have installed the latest reporting extension. It's the same version from the above link you mentioned to me.
Suggested answer

Flydancer 1,332 on at

Like (0)

Report

RE: SSRS using Microsoft Dynamics 365 Fetch as DataSource

Hi Fikri,

like stated before you have to use the organization name, not the organization id