Small and medium business | Business Central, N...

API Connectors

(1) Share

Report

Posted on by Community member

I have a cloud based version of BC. My previous work used on premise version. We could easily access the tables with on premise versions to get into MS Query and Power BI.

The cloud based version is not so friendly to do this. What is the best methodology of getting access to the tables through a cloud deployment?

Should we use APIs or is it something Azure services can do?

At the moment we access through Odata feeds, however these don’t get the full columns of data like the tables do…..

cheers

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 81,970 Super User 2025 Season 1 on at

Like (0)

Report

API Connectors

The database cannot be accessed directly in the Cloud environment.
What can be accessed in Power BI are APIs and Web Services. So if the standard APIs cannot meet your needs, you need to publish the required data to Web Services first, or customize the APIs page.

Hope this helps.

Thanks.

ZHU
Suggested answer

Gerardo Rentería Ga... 17,839 Most Valuable Professional on at

Like (0)

Report

API Connectors

Hi

Here's something related to what you indicate.
I would tell you that APIs give you many possibilities.

Losing Direct Access to SQL Server from Business Central SaaS (archerpoint.com)

API (v2.0) for Dynamics 365 Business Central - Business Central | Microsoft Learn

API – Kauffmann @ Dynamics 365 Business Central

BR

GR