Power bi Dataflows Virtual Tables Dataverse Business Central

[Jarcio]

Hello,

I try to get the lines of orders and invoices but when I conect to the table orderlines or invoicelines I get this error message "You must specify an Id or a Document Id to get the lines", if I go the table of orders or invoices and try to expand the colum that contains the lines, I get another error message: "RelationshipQueryCollection is not supported."

In fact, in dataverse, if I go to the lines table and try to see the data, I get the error message: "You must specify an Id or a Document Id to get the lines."

So, is there a way to access to the lines of orders, invoices, and so of Business Central in Dataverse virtual tables?

I have searched and just found this post which does not offer a solution: 

(+) BC Virtual Entity Salesinvoiceline error in CDS - Dynamics 365 Business Central Forum Community ...

thanks a lot for your help,

[v-kelly-msft]

Hi  @Jarcio ,

Check the reference below:

https://ruudvg.com/2019/05/26/microsoft-business-central-api-beta-create-a-sales-order-and-sales-ord...

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!