20
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.
Thank you very much Zhu!
Hi Daniele,
Thanks!!
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (