DataSource.NotFound: OData: Request failed (404): The remote server returned an error

[vcmoffatt]

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?

[gabriel94mx]

Do you resolve the OData problem?

[v-yuezhe-msft]

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

[vcmoffatt]

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

[v-yuezhe-msft]

Hi @vcmoffatt，

Are you able to connect to the CRM content pack from Power BI Service?

Thanks,
Lydia Zhang

[vcmoffatt]

Hi,

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=h...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%2...xxx.api.crm4.dynamics.com%252fXRMServices%252f2011%252fOrganizationData.svc&Popupui=1'."

Any ideas on this?

thanks in advance

Victoria

[vcmoffatt]

Ignore, the last post, I've realised what the problem was, it was to do with my credentials.

[v-yuezhe-msft]

Hi @vcmoffatt,

It seems that you have resolved this issue. You can accept helpful replies as solution, that way, other community members would benefit from your solution.

Thanks,
Lydia Zhang

[vcmoffatt]

Hi, no i didn't solve the original issue. I solved the issue from last thursday but not what I originally posted about.

[BenHoward]

I found this error both in Excel and PowerBI Desktop.  The issue was too many columns, and removing some of them in PQ immediately after connecting to the source resolved the issue in both products.  For me it was failing in Project Server 2016 (PWA) on premise application when connecting to http://<site>/pwa/_api/ProjectData