Dynamics 365 fetch xml connection not working

(0) Share

Report

Posted on by Community Member

Hello i'm currently trying to connect to our online dynamics 365 data using (vs2012 business tools SSDTBI_VS2012_x86_ENU) and the (CRM2016-Bids-ENU-i386) report authoring tool. I create a data connection using the Microsoft Dynamic CRM Fetch option and then when i try and run my report i get the following error

2308.connectionerror.png

I'm not sure if im using the correct connection string url for the connection. I'm using my O365 credentials ( i have admin rights on CRM and i can connect using PowerBi etc)

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

maxp 45 on at

Like (0)

Report
Copy link

Link copied!

I have the same exact issue....Any help from Microsoft?

Was this reply helpful? Yes No
Suggested answer

Nadeeja Bomiriya 6,804 on at

Like (0)

Report
Copy link

Link copied!

Hi jrt1970,

Try changing the proxy settings on IE of the server. May be tick "Bypass Proxy Server for Local Addresses".

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Use the following connection string

https://disco.crm4.dynamics.com;%yourOrgaName%

See the link below.

https://community.dynamics.com/crm/f/117/t/109795

Hope this helps.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Nadeeja, I've ticked bypass proxy server.

I've manage to pull back some simple account information in the BIDS environment

Was this reply helpful? Yes No
maxp 45 on at

Like (0)

Report
Copy link

Link copied!

Nitya,

Thanks for the reply. Unfortunately, mine is a Dynamics CRM online subscription.

Connectionstring should look like this?

disco.crm4.dynamics.com;%orge5a5e0d7%

Was this reply helpful? Yes No
maxp 45 on at

Like (0)

Report
Copy link

Link copied!

disco.crm4.dynamics.com;%orge5a5e0d7%

Was this reply helpful? Yes No
Suggested answer

maxp 45 on at

Like (0)

Report
Copy link

Link copied!

For me I had to update the Dynamics CRM Report Authoring Extension to the latest version to make anything work.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

If your organization is in Dynamics 365 V9, your have to install the latest version of BIDSExtensions. This one for example https://www.microsoft.com/en-us/download/details.aspx?id=56973

and it will works.

Alle

Was this reply helpful? Yes No