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.

All responses (4)

Answers (2)

Eduardo Diaz 20 on at

Like (0)

Report

RE: How to work with a financial report on Power BI

Thank you very much Zhu!
Eduardo Diaz 20 on at

Like (0)

Report

RE: How to work with a financial report on Power BI

Hi Daniele,

Thanks!!
Verified answer

YUN ZHU 73,378 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to work with a financial report on Power BI

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
Verified answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to work with a financial report on Power BI

hi

look this

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

DAniele