Skip to main content

Notifications

Business Central forum
Answered

Required BC Tables not available in PowerBI

Posted on by Microsoft Employee

Hi,

Choosing Business Central as a Data Source in PowerBI offers plenty of tables, but not all of them.

Is there a way to load more Business Central tables than offered into PowerBI? Exporting a table from BC to Excel and then loading that into PowerBI is not an option, because it is no live data.

More precisely I can not load the following table into PowerBI:

  • Page "Item Bin Contents (7379, List)", table "Bin Content (7302)"
  • Page "Lot No. Information List (6508, List)",  table "Lot No. Information (6505)"
    and a little more special: 
  • page "Lot Numbers by Bin FactBox (9126, ListPart)", temporary table "Lot Bin Buffer (7351)"
    This table shows the exact data I want to visualize, but its a temporary table, so I have low hopes to get this one into PowerBI.

I'm looking forward to your answers!

Alex

Categories:
  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,043 Moderator on at
    RE: Required BC Tables not available in PowerBI

    Adding new pages via the Reporting Data Setup wizard is a solution, however not all pages are suited for Power BI and the might not contain the fields you need.

    Better is to develop new API Queries with aggregated data (method=Sum, group-by) with exactly the tables/columns you need.

  • Verified answer
    Alfredo_Iorio Profile Picture
    Alfredo_Iorio 1,260 on at
    RE: Required BC Tables not available in PowerBI

    Hi.

    Not all tables are available in the standard Power BI connector.

    You need to expose the tables you need via API using the Web Service page in Business Central.

    pastedimage1661936534666v1.png

    Use the Create Data Set action and you will be guided to a setup where you can choose the table and the fields to expose.

    Once done, the table data will be visible in Power BI.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Required BC Tables not available in PowerBI

    Hi Amit,

    I have Dyn365 BC Premium and Power BI Pro License

  • Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Required BC Tables not available in PowerBI

    Hi,

    Pls check License of BC D365 and Power BI.

    Regards

    Amit Sharma

    www.erpconsultors.com

    https://www.linkedin.com/in/amit-sharma-94542440/

    Press Yes if info is useful.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans