The Data Access app exposes 60 tables from Microsoft Dynamics 365 Business Central as API endpoints.

You can use this to connect Microsoft Power BI to your Business Central - or to enrich any other IT solution with your ERP-data.

The app complies with all Microsoft standards – and it’s updated with each and every new version of Business Central. When tables and fields are changed in Business Central – so is the Data Access app. Usually, simple changes in Business Central requires help from an external consultant to update the API, but your subscription to the Data Access app ensures that you have no maintenance task.

With the Data Access app, your BI will work uninterrupted by changes in Business Central.

This is what you get

Every time, you need ERP-data for other IT-solutions, like Business Intelligence, you can use the Data Access app. You get the 60 most commonly used tables from Business Central including all regular fields.
Request data from Business Central with a GET, and you receive a JSON response.
To extract data to your reporting or data storage solution, add your preferred integration solution, eg OData connector for Power BI, Azure Logic Apps, Data Factory or Azure functions.
When configured, the app keeps track of deletions in relevant tables, so your integrations only need to load the most recently modified data to stay updated. The app is frequently updated to support updates of Business Central from Microsoft. The API will always expose the current Business Central table structure.

Limitations and Possibilities

The data displayed does not include calculated data fields and flow fields. Included tables are listed in the image.
You may need to adapt your integration when Microsoft changes the table structure of Business Central.
You can extend this app. If you need more data, you can expand the data model or hire us to do so. But in most cases, it will not be necessary.

Abakion is a leading provider of apps for Business Central. Among the top-100 most popular apps, 21 are from Abakion. We were among the first on AppSource, and today we offer a comprehensive suite of 30+ apps. You even get a big discount with our App Bundle. Abakion is a one-stop shop for Apps.

Supported editions: This app supports both the Essential and Premium edition.
Supported countries: All countries where Microsoft Dynamics 365 Business Central is available.
Supported languages: English

Data Access - API data integration

avtor: Abakion