Forum Discussion
DataSource.NotFound: OData: Request failed (404): The remote server returned an error
I have a few reports where I have hooked into Microsoft Dynamics CRM 2016 and all were working well. But now gradually for no apparent reason on various different pbix files the data source appears to be breaking with the following error message:
DataSource.NotFound: OData: Request failed (404): The remote server returned an error: (404) Not Found. (Not Found).
Nothing should have changed, I am logged in correctly. I don't understand why the connection is breaking.
Any help?
9 Replies
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 ZhangHi,
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 Zhang
Do you resolve the OData problem?
