How to Create your first PowerBI Dashboard for Business Central Dashboard

To connect Power BI to Dynamics 365 Business Central and create your first dashboard, follow these steps:

Open Power BI Desktop: If you haven’t already, download and install Power BI Desktop from the Microsoft website. Launch the application.

Get Data: In Power BI Desktop, click on  “Get Data from another source ” when you start up PowerBI Desktop Or “Get Data” from the Home tab in the ribbon menu.

Screenshot 2024 05 13 154110

Or …

Choose Data Source: In the “Get Data” window, search for “Dynamics 365 Business Central” in the search bar or navigate to it in the list of available connectors. Click on it and then click “Connect”.

Screenshot 2024 05 13 154110 1

Authentication: You will be prompted to sign in. Enter your Business Central credentials.

Select Data: Once authenticated, you will be presented with a navigator window showing available tables and entities from your Business Central instance. Select the tables you want to import data from for your dashboard. You can select multiple tables if needed.

I selected CUSTOMERS for now.

Screenshot 2024 05 13 154110 2

Transform Data (Optional): You may need to clean and transform the data to suit your dashboard requirements. Power BI provides a range of tools for data cleaning and transformation. Click “Transform Data” to open the Power Query Editor.

Screenshot 2024 05 13 154110 4

Load Data: After transforming the data (if necessary), click “Close & Load” to import the data into Power BI.

Create Visualizations: Once the data is loaded into Power BI, you can start creating visualizations for your dashboard. Drag and drop fields from your dataset onto the report canvas to create charts, graphs, tables, etc.

Screenshot 2024 05 13 154110 5

Design Dashboard: Arrange your visualizations on the report canvas to create your dashboard layout. Customize the visualizations as needed by adjusting their properties from the formatting pane.

Save Dashboard: Once you’re satisfied with your dashboard, save your Power BI file (.pbix) to your desired location.

Publish to Power BI Service: If you want to share your dashboard online or collaborate with others, you can publish it to the Power BI Service. Click on “Publish” from the Home tab in Power BI Desktop, and follow the prompts to publish your dashboard to the Power BI Service and workspace of your chosing.

Screenshot 2024 05 13 154110 6

That’s it! You’ve now connected Power BI to Dynamics 365 Business Central and created your first dashboard. You can continue to refine and enhance your dashboard as needed.

How to create your first PowerBI Dashboard for Business Central Video

Learn more about Business Central Next Steps: 

Discover Microsoft Dynamics 365 Business Central

Posted by iCepts Technology Group, Inc. a Microsoft Dynamics Business Central Reseller in Pennsylvania 

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

117