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

Power BI API vendor table not showing all fields

(1) Share

Report

Posted on by LF-16052033-0

575

Hello,

When connecting to Business Central to Power BI, how can you see all the fields from the Vendor Table through the APIs connection?

is there a way to make all the fields available on all of the tables from BC?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Valentin Castravet 32,200 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Out of the box not all, but quite a few fields are available. If a field is not available, a developer can create a copy of the API and add the missing field, its pretty simple to do.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,084 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, because what is connected in Power Bi is not a table but a page. The fields are not added to the page, so not all fields are displayed.

If you are connecting to a Web Service (Odata), you can add the fields to the page first so that they will also appear in Power Bi.
If you are connecting to a standard API, unfortunately this requires customization as of now.

More details: Dynamics 365 Business Central: Can we extend standard APIs? – Download Standard Source Code for APIs

https://yzhums.com/20960/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,419 User Group Leader on at

Like (1)

Report
Copy link

Link copied!

Hi,

I don't think you need all fields as there can be so many fields - Microsoft Extension, PTE and ISV Extension.

Make a list of fields that you need and create a custom API to have data available in API to Power BI.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,686 Moderator on at

Like (0)

Report
Copy link

Link copied!

BC exposes APIs and APIs get certain fields from certain tables. The OOTB APIs are usually based on Page APIs, which are slower compared to Query APIs when only reading data, as you do in Power BI. A user can not edit these APIs, and developers can also not extend APIs, they need to develop new ones.

My suggestion is to always develop your custom Query APIs for any Power BI reporting. It's not difficult to do, and if you want to learn how, then have a look here:

Learning journeys - Companial

Business Central Booster | Case-Based Learning | Plataan

Training Microsoft Dynamics 365 Business Central, Dynamics 365 NAV, Dynamics 365 CRM, Power BI, Office 365 | Plataan.TV

Was this reply helpful? Yes No