Announcements
No record found.
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
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.
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 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.
What do you mean by expand the lines
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.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,060 Super User 2026 Season 1
YUN ZHU 1,086 Super User 2026 Season 1
Khushbu Rajvi. 700 Super User 2026 Season 1
