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.
What do you mean by expand the lines
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/developer/devenv-api-pagetype
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sumit Singh 3,227
Nimsara Jayathilaka. 2,866
Sohail Ahmed 2,682 Super User 2025 Season 2
