Skip to main content



No record found.

Business Central forum
Suggested answer

API Connectors

Posted on by 4
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…..
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 64,086 Super User on at
    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.
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 5,036 Super User on at

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans