How to Leverage Power BI for Dynamics 365

Data reporting and visualisations are powerful features of Dynamics, and provide organisations with the visibility of how the business is performing at a granular level. There are scenarios where a business will need very specific information, presented in a unique way that makes sense to them. This is where Power BI shines and can be integrated with your Dynamics system to present beautiful, insightful presentations of your data that you can act on.

Prerequisites

Power BI Pro requires a licence, which starts at £7.50 per month, per user. This licence entitles you to modern, self-service analytics to visualise data with live dashboards and reports, and share insights across your organisation. For advanced features such as bigger data models and AI features, you may need Premium. Pricing and feature comparisons can be found on the Power BI website Pricing & Product Comparison | Microsoft Power BI.

Importing Power BI dashboards into Dynamics

If you are looking for a new Power BI dashboard to show inside your Dynamics app, navigate to Dashboards on the left-hand side and select New + on the top menu.

You can choose to create a Power BI Dashboard on its own. You can also display multiple reports and other Dynamics data by clicking Dynamics 365 Dashboard

Choose Dynamics or Power BI Dashboard

When you select ‘Power BI Dashboard’, a new window will surface, enabling the user to choose pre-configured Power BI reports that they have access to.

Choose Power BI Report>

When the user clicks save, this will open the report and be saved in Dynamics for this user to return to. The default report landing page (usually a summary) will appear but can be explored by double-clicking the page, which will open the full report.

Power BI report full screen

The report tabs sit along the bottom of the window to explore specific insights.

You can also share your dashboard with other Dynamics users and control how they can use it.

By selecting Share Dashboard on the top menu, you will surface a window allowing you to add and change user's permissions for the dashboard, such as Read and Write.

Share Power BI Dashboard in Dynamics 365

How to create Dynamics Power BI Reports.

If you are new to Power BI and producing data visualisations, there are off-the-shelf data reports specifically for Dynamics that you can use to connect to your data.

Login to Power BI and navigate to ‘Apps’ on the left-hand menu.

This will display a window for you to search third-party report templates.

Search for Dynamics 365 Power BI Report apps>

Search for Dynamics, and you will see Microsoft-produced reports such as Sales Analytics or Customer Service. Choose one and select ‘Get it now’

You will now be able to see the full report using sample data.

Connect Power BI Report to your Dynamics 365 data

To use your Dynamics systems data, you will need to connect and authenticate using your instance URL and user name by following the instructions in the window. This should now use your systems data to gain meaningful insights into your business's operations.

We have posted some helpful Microsofts Power BI Dynamics 365 template links for you to get started:

Business Central – Finance

Process Analytics

Dynamics 365 Sales Insights

Dynamics 365 Customer Service Analytics

Dynamics 365 Business Central

Dynamics 365 Marketing Analytics

One of the key strengths of Power BI is its exportability. You can share with your colleagues in a variety of methods such as PDF, Microsoft Teams, embed into Web Portals, include it in your Dynamics Dashboard and so on. This can make collaboration and meetings more productive and able to make better decisions.

Most organisations will want to build their own reports to get a customised view of their business data. At Serversys we can support you with this and are available to help you get the visibility you require.

Recent updates

Discover Dynamics 365 Copilot

Introducing Dynamics 365 Co Pilot

Customer Story: Toyota to Dynamics

toyota case study

CRM Buyer's Guide 2023

crm buyers guide 2023