Configure Business Central for Excel and Power BI

Functional Consultant
Business User
Dynamics 365
Business Central

Make Business Central data available for easy reporting with Excel and intelligent analysis with Power BI.

Learning objectives

By the end of this module, students will be able to:

  • Create Business Central web services that can be used as data sources in Power BI
  • View data in Power BI reports in Business Central
  • Enable business data for Power BI
  • Export business data to Excel


Basic understanding of working with Business Central, Microsoft Excel, and Power BI.