Announcements
Dears,
i need to know which tables i have to use to recreate P&L statement in Power BI
I need also the asset/entities tables and chart of accounts
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.
You will need to use at least two tables: G/L Account and G/L Entry.
The rest depends on your BC environment.
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,081 Super User 2026 Season 1
YUN ZHU 1,351 Super User 2026 Season 1
Grigorios Mavrogeorgis 1,168 Super User 2026 Season 1
