Skip to the main content.

Technology

As the preferred Microsoft Dynamics 365 and Power Platform Service provider, TrellisPoint has the expertise to help your business grow the strategic way.

 

Dynamics 365

Microsoft Dynamics 365, a comprehensive suite of intelligent business applications designed to revolutionize the way you manage and grow your business.

 

Artificial Intelligence

Radically accelerate your productivity with AI features built directly into Microsoft tools and services.

Microsoft Co-Pilot 
copilot365

 
Resources
Connect with Us

Contact Form

Phone: 888.719.0248
Social: LinkedIn Icon 100x100 Twitter Icon 100x100 Facebook Icon 100x100 YouTube Icon 100x100

 

Resources
Connect with Us

Contact Form

Phone: 888.719.0248
Social: LinkedIn Icon 100x100 Twitter Icon 100x100 Facebook Icon 100x100 YouTube Icon 100x100

 

Resources
Connect with Us

Contact Form

Phone: 888.719.0248
Social: LinkedIn Icon 100x100 Twitter Icon 100x100 Facebook Icon 100x100 YouTube Icon 100x100

 

2 min read

How to add Power BI dashboards to Dynamics 365: A Step-by-Step Guide

How to add Power BI dashboards to Dynamics 365: A Step-by-Step Guide

Tutorial: How to add Power BI dashboards to Microsoft Dynamics 365

Microsoft Dynamics 365 already includes a built-in dashboarding feature with acceptable charts, lists and basic drill-down capabilities. By default, the Dashboards page will be the first thing most users see when they log in through the web interface:

Power BI

But these dashboards pale in comparison with the full capabilities and superior aesthetics of Microsoft’s flagship analytics platform, Power BI. The good news is that you can add a fully functioning pre-built Power BI dashboard to Microsoft Dynamics 365 using your own data, and appearing totally seamless as if it had been part of it all along. The even better news is that it’s easy, quick, and completely FREE.

Let’s get to it!

Step 1: Get Power BI

If you don’t have Microsoft Power BI yet, click here to get it. The button might say something like “Try Free” but don’t worry, it’s not a limited-time trial. Click here to see the pricing page describing what the free edition gets you, as well as the more advanced paid editions.

You do not need to download the “Power BI Desktop” edition. It’s a powerful interface for more advanced Power BI customizations, but not necessary for the purposes of this article. For now let’s stick with the web-only interface, which after login will look something like this:

Power BI

Step 2: Find the right Connector or “App” for Power BI

Find and click the “Get Data” button. As of this writing it is located in the bottom-left corner of the page.

The AppSource window will appear. Scroll down, or better yet, type “Dynamics 365” in the search bar:

As you can see in the image above, there are applications for many different online platforms, which is one of the features that makes Power BI so… well, powerful. You can gather data from multiple data sources outside of Dynamics 365, and visualize it neatly in dashboards within one single interface.

There are Apps available for various parts of Dynamics 365 including Sales, Financials, Marketing, Social Engagement, etc. For the purposes of this guide, we’ll choose “Sales Analytics for Dynamics 365”, and click “Get it now”.

Power BI

Step 3: Connect Power BI

In the following dialog, enter the appropriate URL for your Dynamics 365 organization, and last month of the organization’s Fiscal Year:

If you’re connecting to Dynamics 365 Online, simply enter the normal URL you’d use to log in from your browser. For example, if my organization name is “Contoso”, I would enter: https://contoso.crm.dynamics.com
If you’re connecting to Dynamics 365 on-premises, unfortunately there are a few more technical steps required. Please refer to this article for more details.

Then if the Contoso organization’s fiscal year runs January through December, I would enter 12.

Click Next. If prompted, under Authentication Method, select oAuth2. Then wait while Power BI reads the data.

After waiting somewhere between several seconds to a few minutes (depending on how much data your organization has), Power BI will show the new Dashboard. It may look grayed-out while it’s reading the data, but it will show a white background and enabled buttons once it’s ready for consumption:

Power BI Power BI

Step 4: Enable Power BI dashboards in Dynamics 365

Log into the Dynamics 365 website, navigate to Settings > Administration > System Settings > Reporting tab, and under Set whether users can embed Power Bi visuals > Allow Power BI visualization Embedding, select Yes and click OK.

Power BI

Step 5: Add the Power BI Dashboard

Still in Dynamics 365, navigate to Sales > Dashboards, then click the dropdown arrow next to the New button > Power BI Dashboard.

Click on the Dashboard dropdown and select the dashboard we created earlier. Click Save.

You will have to wait a bit for all the data to load and the dashboards to display for the first time, but then you will be rewarded with a great-looking live Power BI dashboard right inside Dynamics 365:

Power BI Power BI Step 5: Add the Power BI Dashboard

Furthermore, if you click on the dashboard itself, a pop-up window with the full “Power BI Report” will open, containing multiple dashboard tabs, each with a great amount of high-level as well as detailed information, which will give you an idea of the variety and capabilities behind the Power BI platform.:

Power BI

Learn more about Microsoft D365

 

Book a Demo   Learn More

 

Meeting CIO’s Complex Challenges with Dynamics 365

4 min read

Meeting CIO’s Complex Challenges with Dynamics 365

Chief Information Officers have faced unprecedented challenges in the last few years, and 2024 is poised to serve up even more. From optimizing...

Manufacturing Challenges Solved with Microsoft Dynamics 365 CRM

7 min read

Manufacturing Challenges Solved with Microsoft Dynamics 365 CRM

Manufacturing companies face a multitude of challenges, especially in keeping up with the technology and the demands of an ever-changing workforce...

Solving Business Challenges Faster: Power Platform’s Impact

5 min read

Solving Business Challenges Faster: Power Platform’s Impact

Is your company challenged by trying to integrate multiple standalone tools successfully without making processes even more complicated and...