Use Power BI in Microsoft Dynamics 365 Business Central

Intermediate
Functional Consultant
Developer
Dynamics 365
Business Central

Are you going to use Power BI to create reports for Business Central? If so, this learning path will discuss how to build a dataset, build a report, and work with Power BI and Business Central.

Prerequisites

  • Knowledge of the AL programming language
  • Previous experience using Power BI
  • Knowledge of how to set up a Business Central Cloud Sandbox

Modules in this learning path

Do you want to know how create a dataset for a Power BI report in Business Central? In this module, you learn how to use the assisted reporting setup to expose existing queries and reports as web services. We also discuss how you can develop a custom data set for Power BI and enable your Business Central data for easy Power BI reporting.

Do you want to build a Business Central report using Power BI Desktop? This module will guide you through the steps required to create a Power BI report. We create a start schema, add a data dimension, create the report, and convert it into a nice looking dashboard.

Do you want to know how to work with Microsoft Power BI in Dynamics 365 Business Central? If so, this module is for you. You'll learn how to deploy Business Central dashboards in Power BI and how to set up Power BI inside Business Central.