Forum Discussion
Power bi Dataflows Virtual Tables Dataverse Business Central
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:
thanks a lot for your help,
1 Reply
- v-kelly-msftCommunity Support
Hi Jarcio ,
Check the reference below:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!