Forum Discussion
desertislesql
Most Valuable Professional
Most Valuable ProfessionalError trying to get data from Microsoft Dynamics CRM
We are trying to use the Power Query connection in Office 365 Excel to make an Odata feed connection to CRM. There are about 200 fields we are trying to access. After the fields are added, a window...
There appears to be an error with the way that Microsoft Dynamics CRM was configured, which meant some of the embedded tables were pointing to nothing. Removing all of those tables, which were not being used resolved the connection issue. Tip: Make sure CRM is configured correctly as it can cause a Odata issues.
Greg_Deckler
Community Champion
Community ChampionTry using the guidance here:
What table are you trying to pull in?
My suggestion would be start with a small number of fields without any expansion. I have had the most trouble with Leads.
desertislesqlMost Valuable Professional
Most Valuable ProfessionalI started with pulling in CRM data from customers and that worked fine. Now trying to pull in Sales, which has many fields and has been problematic. I need that data though, so I have to figure out how to make it work.