Forum Discussion

dporter's avatar
dporter
Frequent Visitor
10 years ago
Solved

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   ...
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    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.

dporter's avatar
dporter
Frequent Visitor
10 years ago

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.

rsmccall33's avatar
rsmccall33
Icon for Helper II rankHelper II
9 years ago

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.