Forum Discussion
OData error with Dynamics CRM Online Data Source.Not Found
Greetings.
Greetings,
Using Power BI Desktop - Version: 2.38.4491.282 64-bit (August, 2016)
Note: This issue also occurred in the prior version.
Connecting to a CRM 2015 Online Instance
ODATA FEED.
https://xxxxxxx.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/
It connects and shows the Navigator screen with the available datasets.
A smaller dataset will load fine. A larger dataset ( AccountSet ) generates the following error.
Load : AccountSet Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error:[Data Source.NotFound] OData: request failed (404): The remote server returned an error:(404) Not Found. (Not Found). '.
I used to get this same kind of error dealing with Leads in CRM. I solved it by pairing down a lot of the columns. I had initially just let it choose to bring in all columns and would get issues like that. Getting rid of a lot of the "fluff" solved it in my case.
3 Replies
- Greg_Deckler
Community Champion
I used to get this same kind of error dealing with Leads in CRM. I solved it by pairing down a lot of the columns. I had initially just let it choose to bring in all columns and would get issues like that. Getting rid of a lot of the "fluff" solved it in my case.
OK ... I found a seperate / similar forum post that implied that this issue may be caused by the number of columns ( not rows ) that were being pulled into PowerBI desktop. So I reduce the number of columns using Remove Column option to limit the query. This allowed me to bring in and work with the Account Set.
rsmccall33Helper II
Did you ever locate documentation stating what the column limitation is?
I have a customer experiencing the same problem as you, and I would like to know how many columns we need to cut out.
