How Do I: Build a Power BI Dashboard in Office 365 with Microsoft Dynamics NAV 2015

Jun 3, 2019


Welcome to our comprehensive guide on building a Power BI Dashboard in Office 365 using Microsoft Dynamics NAV 2015. In this tutorial, we will walk you through the step-by-step process of creating a powerful and visually appealing dashboard that utilizes the data from your Dynamics NAV 2015 system.

Why Power BI Dashboard?

Power BI Dashboard offers a wide range of benefits for businesses in the modern data-driven world. With its intuitive interface and powerful visualization capabilities, Power BI allows you to gain valuable insights from your data and make better-informed decisions. By combining the data from your Microsoft Dynamics NAV 2015 system with Power BI, you can unlock the full potential of your business data.

Getting Started

Before we dive into the step-by-step instructions, let's make sure you have the necessary requirements in place:

  • Access to Office 365
  • A valid Microsoft Dynamics NAV 2015 license
  • Basic knowledge of Microsoft Dynamics NAV 2015

Step 1: Connect Power BI to Microsoft Dynamics NAV 2015

To get started, you'll need to establish a connection between Power BI and your Dynamics NAV 2015 system. Follow these steps:

  1. Open Power BI and sign in with your Office 365 account.
  2. Click on the "Get Data" option and select "Dynamics NAV 2015" from the available data sources.
  3. Enter the necessary details to connect to your Dynamics NAV 2015 database, such as server name, database name, and credentials.
  4. Click "Connect" to establish the connection.

Step 2: Import Data into Power BI

Once the connection is established, it's time to import the data from Dynamics NAV 2015 into Power BI. Follow these steps:

  1. Select the tables or queries you want to import into Power BI.
  2. Apply any necessary filters or transformations to the data.
  3. Review the data preview to ensure the correct data is being imported.
  4. Click "Load" to import the data into Power BI.

Step 3: Create Visualizations

With the data imported, you can now start creating visualizations for your Power BI Dashboard. Follow these steps:

  1. Choose the type of visualization you want to create, such as charts, graphs, or maps.
  2. Drag and drop the relevant fields from your imported data onto the visualization canvas.
  3. Customize the visualizations by adjusting colors, labels, and other properties.
  4. Interact with the visualizations to explore the data and gain insights.

Step 4: Design the Dashboard

Now it's time to design your Power BI Dashboard by arranging the visualizations and adding additional elements. Follow these steps:

  1. Create a new dashboard in Power BI.
  2. Drag and drop the visualizations you created onto the dashboard canvas.
  3. Add additional elements such as text boxes, images, or shapes to enhance the dashboard.
  4. Arrange the elements to create a visually appealing and functional layout.

Step 5: Share and Collaborate

Once your Power BI Dashboard is ready, you can share it with others and collaborate on the insights. Follow these steps:

  1. Click on the "Share" button in Power BI.
  2. Specify the recipients with whom you want to share the dashboard.
  3. Choose the level of permissions for each recipient, such as view-only or edit access.
  4. Collaborate with others by adding comments or discussing insights within the dashboard.


Congratulations! You have successfully learned how to build a Power BI Dashboard in Office 365 using Microsoft Dynamics NAV 2015. By leveraging the power of Power BI and your Dynamics NAV 2015 system, you can transform your business data into actionable insights and drive better decision-making. Explore the possibilities, experiment with different visualizations, and unleash the true potential of your data. Start building your Power BI Dashboard today with PopTop SEO, your trusted provider of high-quality SEO services in the Business and Consumer Services industry.

Becky Gomez
Great tutorial on building a Power BI Dashboard in Office 365 using Microsoft Dynamics NAV 2015. Very helpful process walkthrough!
Nov 8, 2023
Adam Stevens
Using Power BI with Office 365 and Microsoft Dynamics NAV 2015 makes data analysis more efficient and visually engaging.
Oct 24, 2023
Jonathan Gelman
The tutorial provides valuable insights into leveraging Power BI for data visualization and analysis.
Apr 26, 2023
Carla Cooling
Power BI is a powerful tool, and this tutorial does a great job of showcasing its capabilities for dashboard creation.
Jan 5, 2023
Vanessa Laurie
This tutorial is really helpful for creating a dynamic dashboard in Office 365 with Microsoft Dynamics NAV 2015.
Jun 29, 2022
Lisa Fiol
I appreciate the step-by-step guide on using Power BI to build a dashboard. It's clear and easy to follow.
Mar 17, 2022
Anthony Mcloughlin
I'm excited to try this out for my own business. Thank you for providing detailed instructions!
Mar 30, 2021
Michael Daniels
The use of Power BI for creating visually appealing dashboards is a game-changer for businesses.
Jan 21, 2020
Paul Lundblad
Thank you for the detailed explanation. It's exactly what I needed to get started with Power BI and Microsoft Dynamics NAV 2015.
Oct 25, 2019
Ryan Makamson
The integration of Microsoft Dynamics NAV 2015 with Power BI is great for analyzing and visualizing the data.
Sep 4, 2019
Patrick Fowler
Creating a dashboard with Power BI and Dynamics NAV 2015 seems much easier after following these instructions.
Jun 27, 2019