Hi Eric
I added a new date field to Purchase Invoices. Doesn’t appear to be returned in the API v2.0 nor ODATA endpoints, so I created an API endpoint that contains the new field.
On Power BI, I noticed the API v2.0 endpoints contain a column with a table containing linked dimension values, lines, etc. I managed to achieve something similar using SOD but I’m still not sure how I did this. I believe it’s the Power BI Business Central connector doing this.
Do you know how to consistently reproduce this?
Thanks!
hougaard Changed status to publish February 21, 2025
It’s because the v2.0 endpoints are handcoded in AL, the “sub table” inside an API is a thing correctly outside the realm of “Simple”.
You can create a separate API for the purchase lines and bind the data sources together in Power BI.
hougaard Answered question February 19, 2025