Forum Discussion

Jarcio's avatar
Jarcio
New Member
5 years ago

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: 

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

 

thanks a lot for your help,