Connecting CRM 2016 to Power Query in Excel 2013 with updated Odata feed

In my previous posts we had discussed about how we can connect Dynamics CRM with Power Bi and Power Query. But with the introduction of API in CRM 2016, there is slight change in the OData feed URL generated for CRM 2016.

Using the same process mentioned in older posts but making use of this new OData feed URL, we can achieve same results for CRM 2016 as well.

The url format is [Your Organization Root URL]/XRMServices/2011/OrganizationData.svc.

e.g.: https://u———–y.api.crm5.dynamics.com/XRMServices/2011/OrganizationData.svc

Advertisements

Get data from Dynamics CRM 2015 to Power BI using connector

Update 20th Feb 2016: 

Connecting CRM 2016 to Power Query in Excel 2013 with updated Odata feed

Original Post:

The Microsoft Dynamics CRM content pack for Power BI Preview allows you to easily access and analyze CRM data in Power BI. The content pack uses the OData feed to create a descriptive model, with all the entities and measures needed such as Accounts, Activities, Opportunities, Product, Leads, Users and more.

After you have Power BI subscription, Click Get Data on the welcome screen.

Select Microsoft Dynamics CRM and click Connect.

Important:

Make sure your popup blocker is disabled or is set to allow popups from app.powerbi.com.

Provide the OData URL associated with your account. This will be in the form “https://mytenant.crm.dynamics.com/XRMServices/2011/OrganizationData.svc

When prompted, provide your credentials (this step might be skipped if you are already signed in with your browser). For Authentication Method, enter oAuth2 and click Sign In:

After connecting, you’ll see a dashboard customized for a Sales Manager, populated with your own data:

 

For more information, see below link. Happy analyzing the data J

https://support.powerbi.com/knowledgebase/articles/462791-microsoft-dynamics-crm