web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Which tables to use to...

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

Suggested Answer

Which tables to use to recreate P&L statement in Power BI

(0) Share

Report

Report

Posted on by alansalloum

30

Dears,

i need to know which tables i have to use to recreate P&L statement in Power BI

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

alansalloum 30 on at

Like (0)

Report
Copy link

Link copied!

I need also the asset/entities tables and chart of accounts

Was this reply helpful? Yes No
Guy McKenzie 1,340 on at

Like (0)

Report
Copy link

Link copied!

The financial data is in the general ledger entries table.

You may also want dimension set ID if you want to do P&L by dimensions other than the two global dimensions.

You need the g/l accounts and possibly account categories to build your report structure.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,302 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You will need to use at least two tables: G/L Account and G/L Entry.

The rest depends on your BC environment.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,926 Super User 2026 Season 1

#2

YUN ZHU 1,103 Super User 2026 Season 1

#3

Kamal Khakhkhar 695

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans