Required BC Tables not available in PowerBI

(0) Share

Report

Posted on by Community Member 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

All responses (4)

Answers (1)

Suggested answer

Steven Renders 5,051 Super User 2024 Season 1 on at

Like (0)

Report

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 1,260 on at

Like (0)

Report

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.

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 Microsoft Employee on at

Like (0)

Report

RE: Required BC Tables not available in PowerBI

Hi Amit,

I have Dyn365 BC Premium and Power BI Pro License
Amit Baru 3,025 on at

Like (0)

Report

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.