How to work with a financial report on Power BI

(0) Share

Report

Posted on by Eduardo Diaz

Hi everyone and thank you in advance,

I am trying to work with the information of a financial report of BC in Power BI, but when I try to get data from the API in Power BI that connects with Business Central, I can see several sources of data, like customers, etc., but I don't know how to bring a P&L from BC to Power BI in order to work with it.

Any help would be very appreciated.

Regards and thanks!

Eduardo D.

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

DAnny3211 11,421 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi

look this

learn.microsoft.com/.../across-working-with-powerbi

DAniele

Was this reply helpful? Yes No
Verified answer

YUN ZHU 100,552 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Simply put, when you open Power BI and connect to Business Central data, you will see three collections.

Advanced APIs and Standard APIs are standard API pages provided by Microsoft. If you want to add new ones, you need to customize your own API pages.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype

https://yzhums.com/20960/

Web Service (legacy) is the Odata data published in the Web Service page in BC, you can add the existing page from BC to Web Service, and then access it from Power BI.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services

Finally, please note that the performance of API is much better than that of Web Service.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Eduardo Diaz 20 on at

Like (0)

Report
Copy link

Link copied!

Hi Daniele,

Thanks!!

Was this reply helpful? Yes No
Eduardo Diaz 20 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much Zhu!

Was this reply helpful? Yes No