You’re offline. This is a read only version of the page.
Announcements
152
We recently migrated to the Cloud from On-prem and would like to start using Power BI. I was able to connect and the majority of the tables appear however the ones i am really looking for are giving me an error. I am using the Standard API that come with the system
In the standard API there is a special function for retrieving the order lines from a sales header.
That is what is called expanding. So that functions makes some of the standard API not so suitable for Power BI reports. Especially API's where the data consists of head and lines like sales orders and purchase orders.
The standard apis are good to start with, however the 'lines' apis can not be called directly. Better is to go via the salesOrders api, and in there expand the lines.
Alternatively, you can create new APIs pages, or publish existing pages to the Web Service.
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services
This can all be found in Power BI. Of course, the performance of APIs pages is better than that of Web Services
Hope this helps as well.
Thanks
ZHU
The standard API's are probably not your best choice for this use.
Because this needs to be called in the context of a sales header.
Look in the web-service folder for the item called saledDocumetLines instead.
#1
André Arnaud de Cal...
294,095
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
