cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
trevormolag
Frequent Visitor

Connecting to Dynamics CRM (365) Online Error: "Failed to update data source credentials"

I was getting an error when trying to connect to our Dynamics CRM Online 2016 via the "Sales Manager" content pack.  Instructions here say to enter the service URL of your Dynamics CRM account, i.e. https://company.crm.dynamics.com. I did that.

 

"Failed to update data source credentials".  

 

Not a very helpfu error message. 

 

Seemed like Power BI was blindly appending "/api/data/v8.0/" to the URL entered in the box. 

 

Anyways, it took me way too long to figure out that the URL I needed to enter was https://company.api.crm.dynamics.com, so that the above text could be appended to the URL (completed as https://company.api.crm.dynamics.com/api/data/v8.0/), and my oData found.

 

It worked, even though my CRM's developer tools say that the service root URL is at https://company.api.crm.dynamics.com/api/data/v8.1/ (8.1, not 8.0)

 

I'm not sure if this issue is unique to me or not, but it seems like this whole process could/should have been a lot smoother and may need an update. I am also sharing this for the benefit of others.

1 ACCEPTED SOLUTION

Accepted Solutions
trevormolag
Frequent Visitor

Re: Connecting to Dynamics CRM (365) Online Error: "Failed to update data source credentials&am

Thank you for your reply. 

 

I tried it again this morning, and came to the realization that I was having issues because I failed to place the "https://" before company.crm.dynamics.com.

 

When I entered company.api.crm.dynamics.com, I must have remembered the "https://".

 

Definitely my fault, but I can see how others might have similar problems.

View solution in original post

2 REPLIES 2
Microsoft
Microsoft

Re: Connecting to Dynamics CRM (365) Online Error: "Failed to update data source credentials&qu

@trevormolag

 

I just tired on my side but I can connect successfully with https://company.crm.dynamics.com. The URL will be appended automatically as https://company.crm.dynamics.com/api/data/v8.0/.

Then I tried with https://company.api.crm.dynamics.com, it still can be used to connect.

 

It seems that both links work on my side. You can use the second URL as alternative and report again if you cannot connect with both URLs.

 

Best Regards,

Herbert

trevormolag
Frequent Visitor

Re: Connecting to Dynamics CRM (365) Online Error: "Failed to update data source credentials&am

Thank you for your reply. 

 

I tried it again this morning, and came to the realization that I was having issues because I failed to place the "https://" before company.crm.dynamics.com.

 

When I entered company.api.crm.dynamics.com, I must have remembered the "https://".

 

Definitely my fault, but I can see how others might have similar problems.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.