Microsoft Dynamics CRM Data Provider for Excel Power Query

A new feature in Excel Power Query March Update is the Microsoft Dynamics CRM Data Provider.

Microsoft Dynamics CRM Data Provider

In previous versions, OData provider was used to extract data from Microsoft Dynamics CRM as described in this post. In this version, OData provider is still used behind the scenes when selecting the Dynamics CRM Online provider, which means data can still be filtered by adding OData filters to the URL as described in this post. This is important since without any filters, Power Query maybe importing huge amount of redundant data which is not required for your report, while wasting precious resources.

So what is the big difference from previous versions? As far as I can tell, a slightly more friendly UI which indicates the expected URL format and warn the user if the target URL is invalid before actually trying to retrieve data.

OData service URL format validator

OData service URL

The rest of the process hasn’t changed.

Sign in

 

Select data tables

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s