Create a dataset for a Power BI report in Dynamics 365 Business Central
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.
Learning objectives
In this module, you will:
- Install Power BI Desktop
- Use Business Central as a data source in Power BI
- Create queries using the assisted setup and the API
- Develop query and page objects for Power BI
- Weigh the performance impact
- Enable your Business Central data for Power BI
Prerequisites
- Knowledge of the AL programming language
- Previous experience with using Power BI
- Knowledge of how to set up a Business Central Cloud Sandbox