Using Web Services and Power Query with Business Central

  • Tuesday, October 11, 2022:9:40 AM - 10:40 AM
  • Room: Tampa 1 - Convention Center, Level 2
  • Session Number:  824


Every business will need to export Business Central data—especially for the purposes of reporting. Web services is one tool within Business Central you can use to export data to other applications, such as Excel and Power BI. In this session, we will walk through the process of pulling data from Business Central into other apps via Web services, then merging data tables using Power Query for reporting purposes.

Complete Session Survey Here

Learning Objectives

Set up a Web service within Business Central.

Export Business Central data via various Web services to Excel or Power BI.

Utilize Power Query to merge Business Central table data in Excel and Power BI.



Jack Walther
Senior Developer
Syvantis Technologies, Inc.
Janelle Riley
Syvantis Technologies, Inc.