Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

How to get info from Assembly BOM table in power bi

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

My company is using Business Central and Power BI (reporting). I would like to query the "Assembly BOM" table present in Business Central in order to join "co-pack articles" with their child articles.

At the moment I cannot see the "posted sales shipment" table from the "Get Data" tab. 

Is there any reasons why I cannot access this table from Power BI using the "Dynamics 365 Business Central" query connector? Any workaround?

  • Suggested answer
    Steven Renders Profile Picture
    5,512 Moderator on at
    RE: How to get info from Assembly BOM table in power bi

    The best thing to do is to create one or multiple query objects, in a PTE, to serve as datasources for your Power BI report.

    Here are some tutorials on how you can do that:

    thinkaboutit.be/.../

    github.com/.../Workshop - OrderIntake - 2020

    github.com/.../Workshop - Item Availability - 2020

  • rcboiler Profile Picture
    1,150 on at
    RE: How to get info from Assembly BOM table in power bi

    Not all tables are made available out of the box.  Additional web services may need to be built (very easy to do) so they are available in PowerBI.  Do a search on web services from the BC help.

  • matteo4026 Profile Picture
    50 on at
    RE: How to get info from Assembly BOM table in power bi

    Is it a question to us? The answer is: we don´t know. We need to have the Assembly BOM data in POWER BI and although we have imported all table from Business Central we still dont see the Assembly BOM one.

    Does anyone know why?

    Kevin/Matteo

  • rcboiler Profile Picture
    1,150 on at
    RE: How to get info from Assembly BOM table in power bi

    So you need to create a webservice for the BOM table?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans