Using OData with Excel
One of the many benefits of Dynamics 365 Business Central is the way you can easily extract data to connect via integration, ETL tools, API, OData, Power BI and more. One of my favorite parts of the web services feature is the ability to take a data query or page and create a report in Excel in a few simple steps.
Here are the steps to do this:
1. Inside Business Central, search for web services:
7. Copy and paste the URL from step 6 in the URL box. Click OK.