Skip to main content

Microsoft Dynamics CRM Online gets its own Power Query data source

by Jason Gumpert
March 10 2015

Excel Power Query data source Microsoft Dynamics CRM Online

Connecting Microsoft Dynamics CRM Online and Excel Power Query just got a little easier.

The Excel team announced recently that they have added a more streamlined Microsoft Dynamics CRM Online connector for Power Query. The update eliminates the OData feed setup process that has been required.

While the new connector appears to offer the same type of connection, the team says the raw OData approach "was not very discoverable for the majority of our users."

The new CRM Online connector is found under the "From Other Sources" selector in Power Query, meaning Dynamics CRM Online now joins other named connectors for systems from SAP, Salesforce, Facebook, and more. The prebuilt connector means you select Dynamics CRM Online, supply a feed URL and credentials for the organizational account, and Power Query connects and retrieves the list of tables and entities available in the Dynamics CRM endpoint.

As before, the Power Query navigator pane will allow users to pick one or multiple tables from Dynamics CRM and select and edit them as with any other data source. The user can select and preview items, apply transformations to fields, and can load tables into the data model.

Adding Dynamics CRM Online to the list of pre-built connectors should come as a welcome bit of progress for the Dynamics CRM community. Microsoft promised on - and delivered - a similar connector for Salesforce shortly after announcing their ...

FREE Membership Required to View Full Content:

Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Jason Gumpert

As the editor of, Jason oversees all editorial content on the site and at our events, as well as providing site management and strategy. He can be reached at

Prior to co-founding, Jason was a Principal Software Consultant at Parametric Technology Corporation (PTC), where he implemented solutions, trained customers, managed software development, and spent some time in the pre-sales engineering organization. He has also held consulting positions at CSC Consulting and Monitor Group.

More about Jason Gumpert