Connect to your Business Central data with the Data Access managed API

Data Access for Microsoft Dynamics 365 Business Central

Use the Data Access managed API integration for the most popular tables from Business Central – to connect with Microsoft Power BI or any third-party solution.

The Data Access app exposes 60 tables from Microsoft Dynamics 365 Business Central as REST 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.

Use cases of Data Access in Dynamics 365 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 below.

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.

Tables included in Data Access

Download and install now

Get the app from Microsoft AppSource, and install it in your Dynamics 365 Business Central. The app is only available on the current cloud-edition of Business Central.

Get it on AppSource now »

Microsoft AppSource

Data Access pricing

Please enter the number of users you have in your Business Central.
Pricing is based on the total number of named users in your Business Central subscription with Microsoft.
10 users

Single app

Per named user per month at 10 users.
Single user is DKK 120,00.
Available on the cloud-edition of Business Central.
The more users you subscribe to, the cheaper each becomes. Watch video about the price model »
Add this app to cart with 10 named users at kr.
per user, per month.
Annual subscription (You save 16.67%)
Monthly subscription

As part of the App Bundle

Get this app as one of the 5 apps you can select with the App Bundle.
The App Bundle allows you to pick any 5 Abakion Apps at a great discount.
If you need more than 5 apps, the price of any additional app is reduced to only kr. 42,20 per app per month at 10 users (annual subscription).
Bo Hansen Hansen and Thomas Hasle at Abakion

Talk to a real human

Have a chat with our app managers Bo H. Hansen and Thomas Halse about pricing and subscriptions:
[email protected]

Bo Hansen Hansen at Abakion

This field is for validation purposes and should be left unchanged.


If you have specific questions about functionality or how to get started, you may contact our support team at [email protected] or call us at +45 70 23 23 17. We will help you find the right video guides, if available.

We strive to provide you a qualified response as quickly as possible, at least within 24 hours but often much quicker.

At all times we will keep you informed about who is working on your support inquiry and how soon you can expect a response.