Forum Discussion

desertislesql's avatar
desertislesql
Most Valuable Professional
11 years ago
Solved

Error 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...
  • desertislesql's avatar
    desertislesql
    11 years ago

    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.

desertislesql's avatar
desertislesql
Most Valuable Professional
11 years ago

Latest versions of Power Query and Excell from office 365 made no difference.  Appears to be some sort of data issue in CRM, which is hosted in the cloud.  Still investigating the issue.

desertislesql's avatar
desertislesql
Most Valuable Professional
11 years ago

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.