Forum Discussion
DataSource.NotFound: OData: Request failed (404): The remote server returned an error
Hi vcmoffatt,
Do you connect to Dynamics CRM online 2016 or Dynamics CRM on-premises 2016 in Power BI Desktop? And what URL do you use to connect to CRM? If you connect to Dynamics CRM online data source, could you please connect to Microsoft Dynamics CRM content pack in Power BI Service and check if you get any issues?
Besides, based on my research, the above error could occur when OData URL string is large or large number of columns are pulled into Power BI Desktop. Please check your URL and try to reduce columns, then check if the error goes away.
Thanks,
Lydia Zhang
Hi,
I connect to CRM online. The url i use is
https://xxx.api.crm4.dynamics.com/XRMServices/2011/OrganizationData.svc
I have also read some forums where it implies there is an issue with the number/large columns. Other then removing ones not needed in Query (which I have been doing) how else can I remove them? Also why would it work fine initially, and then fail at a later date?
Thanks
Victoria
Hi vcmoffatt，
Are you able to connect to the CRM content pack from Power BI Service?
Thanks,
Lydia ZhangHi,
Yes I am able to connect to the content pack.
I have now go another issue, I can't even pull anything from MS Dynamics 365 - I get the following error now:
Details: "OData: The given URL neither points to an OData service or a feed: 'https://login.microsoftonline.com/dbb06ee2-1005-4b2e-a774-132be0888ef8/wsfed?wa=wsignin1.0&wtrealm=https://xxx.api.crm4.dynamics.com/&wctx=pr=wsfederation&rm=https%253a%252f%252fxxx.api.crm4.dynamics.com%252f&ry=https%253a%252f%252fxxx.api.crm4.dynamics.com%252fXRMServices%252f2011%252fOrganizationData.svc&wct=2016-12-08T15:18:03Z&wreply=https://cloudredirector.crm4.dynamics.com:443/G/AuthRedirect/Index.aspx?RedirectTo=https%253a%252f%252fxxx.api.crm4.dynamics.com%252fXRMServices%252f2011%252fOrganizationData.svc&Popupui=1'."
Any ideas on this?
thanks in advance
Victoria
