Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Jarcio
New Member

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 ...

 

thanks a lot for your help,

 

 

1 REPLY 1
v-kelly-msft
Community Support
Community Support

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!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors