OData refresh issue with Dynamic CRM Online

[KRaghunathReddy]

Hello,

We are facing the following issue while trying to connect to Dynamic CRM OData feed file.

"The Credentials Provided for the OData source are invalid(Source at https://xxxx.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/XXXXXXXX)" but the given credentials are valid and are able to connect to Dynamic CRM Online.

Our dataset contains "On Premise data" as well. So, we are using Power BI Personal gateway too.

Note: The data refresh is working fine in Power BI Desktop whereas we are facing refresh issue with Power BI Service.

Please help with this issue.

Thanks in advance.

[KRaghunathReddy]

Hello,

We are facing the following issue while trying to connect to Dynamic CRM OData feed file.

"The Credentials Provided for the OData source are invalid(Source at https://xxxx.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/XXXXXXXX)" but the given credentials are valid and are able to connect to Dynamic CRM Online.

Our dataset contains "On Premise data" as well. So, we are using Power BI Personal gateway too.

Note: The data refresh is working fine in Power BI Desktop whereas we are facing refresh issue with Power BI Service.

Please help with this issue.

Thanks in advance.

[Greg_Deckler]

I just ran into this except that I had just recently changed my password. Probably not your case. Did your CRM Online instance recently get upgraded, that looks like the old-style OData service connection but I'd have to double check to be sure. I had some issues with this when our tenant got upgraded and had to switch out the URL to the OData service.

[KRaghunathReddy]

If our dataset connect to only one of the "Dynamics CRM feed file" or "On Premises data sources" the refresh is working fine. We are getting issue when we are having combination of "Online and On Premise" data sources. So, i believe OData service connection is not a problem.

[Gaz]

This is the exact issue I am facing although we are not connecting to any on prem data.  Just to an Azure SQL Database.  It works fine in the desktop version but as soon as we publish it to our PowerBI portal and refresh it, it throws this error:

Data source error: The credentials provided for the OData source are invalid.

However, we then created a single dataset that pulled the top 100 contacts from CRM.  Worked fine in Desktop version, published fine and refreshed fine in the portal.  So its not a credential issue.  We then went back to the original workbook and limited the big datasets to 100 records....again, it all worked find in Desktop and when we published to the portal and refreshed.  But as soon as we remove the restriction on the rows and the full workbook is refreshed it throws the above error.  At a loss as to whether its a timeout issue or too much data...even though the error message indicates credentials.

[Greg_Deckler]

Hmm, that's interesting, I would submit that to the Issues forum:

https://ideas.powerbi.com/forums/360879-issues