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”.

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.

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.

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.

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.

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.