Microsoft Dynamics CRM (Archived)

SSRS using Microsoft Dynamics 365 Fetch as DataSource

(0) Share

Report

Posted on by FikriHailal

121

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

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report

Hi,

did you install the latest reporting extension? If no, Please install it.

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

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (0)

Report

Hi

As suggested above make sure you use the latest version of Report Authoring Extension.

In your connection string I assume the shaded part is your org unique name? If not please try using the org unique name in your connection string as shown in the link below

[View:https://community.dynamics.com/crm/b/crmtipsfromadeveloper/archive/2017/01/23/ms-crm-online-ssrstip1-fetch-data-source-and-connection-string]

If above does not resolve the issue try uninstalling and reinstalling the extension.

Hope this helps

Was this reply helpful? Yes No
Suggested answer

Flydancer 1,332 on at

Like (0)

Report

Hi Fikri,

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

Was this reply helpful? Yes No
FikriHailal 121 on at

Like (0)

Report

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

Was this reply helpful? Yes No
FikriHailal 121 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No
FikriHailal 121 on at

Like (0)

Report

Was this reply helpful? Yes No
FikriHailal 121 on at

Like (0)

Report

Any idea ? anyone

Was this reply helpful? Yes No
Suggested answer

Jharana Baliyar Singh 2,667 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report

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.

Was this reply helpful? Yes No