Microsoft Dynamics CRM Online gets its own Power Query data source

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."


Requires FREE Membership to View

Become a Member Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
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. Jason has also held consulting positions at CSC Consulting and Monitor Group.

Read full bio...