Needed tables to recreate P&L statement in Power BI

[alainsalloum]

Dears,

I need to know which Microsoft Dynamics 365 business central tables i have to use to recreate P&L statement in Power BI 

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

Thanks

[alainsalloum]

thanks a lot

[alainsalloum]

this is what i did and i used the G-L_Entries table and i linked it to COA summary and details based on the chart of account

[v-henryk-mstf · Accepted solution]

Hi @alainsalloum ,

Depending on your needs, you can refer to the following video content. Explains everything about financial statements from start to finish, and I think it is possible to use Power BI for their financial statement requirement.

(87) Power BI: The Income Statement - YouTube

There are also some other related content that is worth referring to.

Build a P&L / income statement report in Power BI in less than 5 minutes - Inforiver

How To Create Profit And Loss (P&L) Statements In Power BI | Enterprise DNA

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.