Microsoft Dynamics CRM

{POWER BI Step by Step} How to connect POWER BI Desktop to CRM online?

Do you want to use POWER BI for something other than what content packs for Sales and Service offer in CRM Online.

Well, you can – you just need to user POWER BI Desktop. Here are the steps:

Click on Get Data and select below options:

clip_image001

clip_image002

Click Connect and mention Org service URL:

clip_image004

Click OK and on next screen Choose Organisational account:

clip_image006

Clicking Sign-in will open up Office 365 Login page, Enter your office 365 credentials:

clip_image007

Once credentials are specified, Click Sign in and you should see following screen:

clip_image008

The message “You are currently signed in” must appear. Click Connect now.

This will start Configuration. Once configured, you will be presented with the following screen:

clip_image009

If you need any POWER BI or CRM assistance, just get in touch.

Hope it helps and Happy CRMing!

Twitter: https://twitter.com/msdynamicsblog
LinkedIn: https://www.linkedin.com/in/deepesh-somani-00296932

Google Play Store:

https://play.google.com/store/apps/details?id=com.dynamicsofdynamicscrm.msdynamicsblog&hl=en

Advertisements

4 thoughts on “{POWER BI Step by Step} How to connect POWER BI Desktop to CRM online?”

  1. Thanks Deepesh! We are migrating from CRM 2011 to CRM 2016 online and the challenge we have is that the Export to Excel feature has been degraded in CRM 2016 online. So we are investigating PowerBI / OData feed but the data set download takes far too long to make that work for us. Is there a way to limit the data downloaded to only those table(s) and columns we actually need? It seems it downloads ALL tables before we can apply the specific filters.

    Thanks,
    Henri

    1. Hi Henri, I got your comment notification really late. Data load does take a bit of time to be honest with you. After the first time refresh you should be able to select entities and columns?

      1. Thanks Deepesh. It seems though that each data query takes about the same amount of time. We have been looking at tools to only query for the entities and columns we need. They do exist but w have had some mixed results with those. Especially when we need related data (I.e. REFERENCING COLUMNS). the tools don’t surface them but the native POWER QUERY does.

        Henri

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