Basic Data Query In Excel from Dynamics 365 Business Central

Accessing the data in Microsoft Dynamics 365 Business Central is easy. The more data you want to access and the more links you need is where complexity comes in. Getting started with extracting simple data is the focus of this video.

In this video I will show you how to:
- Find the web services in Business Central
- Connect to the web service from Excel
- Use Power Query to remove columns, sort and filter data
- Return the data to Excel as a table.

00:00 Introduction
00:36 Find the web services in Business Central
01:26 Use the link from Excel to get data
02:18 Power Query preview window
02:29 Transform the data using Power Query
04:09 Load the data to Excel
04:48 Going back to the query to edit
05:33 Saving the file
06:08 Conclusion

https://www.olympic.co.nz/microsoft-dynamics-365-business-central

Presented By:
Heather Roggeveeen
Senior ERP Consultant
Microsoft Certified Dynamics 365 Business Central Functional Consultant Associate

Видео Basic Data Query In Excel from Dynamics 365 Business Central канала Olympic 33