Integrate Power BI for Custom Entities of Microsoft Dynamics 365

Author: Zohaib Uddin Khan

For the course of this blog, I’m expecting that the reader has some basic knowledge of Dynamics CRM, while if you don’t know Power BI, then not a big deal. The primary focus of this blog is, how to use Power BI for Custom Entities of Dynamics 365 Online?

What is Power BI?

I recommend you refer to my previous blog about What is Power BI?

Setup Power BI:

  • Sign up free for Power BI with your work email address (keep remember your personal email address won’t work such as Hotmail, yahoo, Gmail or etc.). In case, if you don’t have work email address, then create a new Dynamics CRM Online trial and use the newly created *@*.onmicrosoft.com

1

  • Once, you complete the sign-up, you are on the Power BI Landing page.

2

Download Power BI Desktop:

  • In order to bring Custom entities of Dynamics 365 to Power BI, we need the Power BI Desktop to achieve our goal.
  • Download Power BI Desktop.

Or

  • From Power BI Landing page, on the top right corner you can see the Download icon and select ‘Power BI Desktop’.

download-power-bi-desktop

  • Installation of ‘Power BI Desktop’ is pretty straight-forward. So, I’m not going onto that road.

Download Dynamics 365 Content Pack (Optional but recommended):

download-power-bi-desktop

Use Power BI for Custom Entities of Dynamics 365 Online:

At this point, we have all our necessary items to achieve our goal of this post. So, let’s start the ride.

  • Double click on Power BI Desktop,

power-bi-desktop-icon

  • Power BI Desktop will show you a pop-up screen for the ‘Sign-In’. Sign-in with the credentials used in the ‘Setup Power BI’.

power-bi-desktop-first-timer

  • Once, you finish sign-in with your credentials. Click ‘File’ – ‘Open’ and select the ‘Dynamics 365 Content Pack – Sales Manager.pbix’ file. If you want to understand more about the ‘Dynamics 365 Content Pack – Sales Manager’, then check this article.

power-bi-file-open

  • In case, you didn’t download the ‘Dynamics 365 Content Pack – Sales Manager’, then click ‘File’ – ‘New’.
  • Click on ‘Get Data’, then select ‘More’ under ‘Home’. A new pop-up will appear:

get-data-more

  • Search ‘Dynamics’, select ‘Dynamics 365’ component and click on ‘Connect’.

get-data-dynamics-365

  • A new pop-up appear, in which you need to enter your Dynamics 365 OData endpoint URL and click on ‘OK’.

dynamics-365-web-api

  • You can find your Dynamics 365 OData endpoint URL at Settings > Customizations > Developer Resources and locate the URL under Instance Web API.

dynamics-365-odata-endpoint-url

  • A new pop-up will appear, select ‘Organizational Account’ and click on ‘Connect’. In case, you’re not already ‘Sign-in’, then click on ‘Sign-in’ before clicking ‘Connect’.

dynamics-365-odata-feed

  • In my Dynamics CRM Instance, I’ve created a new custom entity named as ‘Event’. Pretty Simple and straight forward, which you can see from below picture. And, created three records in it.

dynamics-365-custom-entity

  • In the navigator pop-up, search ‘event’, select ‘new_events’ from the list and click on ‘Load’.

dyanmics-365-navigator-event

  • Then, I bring ‘Stacked Column Chart’ on the Power BI Desktop – Report (by default selected).
    1. Axis – Location
    2. Value – Number of Attendees

stacked-column-chart

  • Click on File – Save. Once, save click on ‘Publish’ button.

publish-power-bi

  • A successful Publish to Power BI appears. Click on ‘Open Event Report.pbix’ in Power BI.publish-successfull
  • In your browser, you are navigated to app.powerbi.com, Select ‘Event Reports’ and on the chart click on Pin.

event-report-pin-chart

  • A new pop-up appear, select ‘New Dashboard’, enter a name and click on ‘Pin’.

event-dashboard-pin-chart

  • Now, go to your Dynamics CRM Organization – Sales – Dashboard – Click on ‘New’ button and following options are available:
    • Dynamics 365 Dashboard
    • Power BI Dashboard
  • Select ‘Power BI Dashboard’ and a new pop-up appear, choose ‘Event Dashboard’ and click on ‘Save’ button.

crm-power-bi-dashboard

  • Viola! Custom Entity chart using Power BI on Microsoft Dynamics 365.

crm-last

Advertisements

4 thoughts on “Integrate Power BI for Custom Entities of Microsoft Dynamics 365

  1. Hi Zohaib,

    Thanks for the article. Helped a bunch.

    One question, once I get the data into Power BI the costum fields only show the value in the columns listed instead of its label. For example, I have a custom field for vertical. In dynamics the labels are Government, Entertainment, Brands etc, but in Power BI it only shows the corresponding values such as 10000001, 21490000001, 100000007 etc.

    Is there any way to make the labels visable instead of the values?

    Like

  2. Dear Zohaib Uddin Khan,

    I am new in Power BI, I have to develop the Dashboard for the Dynamics CRM.
    I am using Power BI desktop.

    I have gone through many post, but of no use. I explain here my scenario. I am taking Project and Service module for dashboard development. I wanted to connect Project entity. I used following link, I am able to view the table but updated data is not there.

    https://.api.crm4.dynamics.com/api/data/v9.0/ – it is throwing error.
    https://.api.crm4.dynamics.com/api/data/v8.0/ – it is giving me full table but data is not updated.
    https://.api.crm4.dynamics.com/api/data/v8.1/ – it is giving me full table but data is not updated.

    https://.api.crm4.dynamics.com/api/data/v8.2/ – it is giving me full table but data is not updated.

    https://.api.crm4.dynamics.com/api/data/v8.9/ – it is giving me full table but data is not updated.

    related table has no data or old data.

    I mean currently i have 100 records (in the UI) but in the table it is showing only 5 records.

    Could you please guide me, how can I fix this problem

    Thanks

    Mohammad Shahnawaz

    Liked by 1 person

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s