Business Central: How to retrieve revenue gross (incl. VAT) from posted sales invoice lines table with Power BI?

Question

I want to use Power Bi for retrieving the sales data from Business central and didn't find any ways to do it

• How to retrieve the gross revenue on the line level on the posted sales invoice
• How can I retrieve revenue gross on the header,that was posted on my sales invoice 

Is there any easy way to do that? 

Answer 1

There are Sales Document line entity page that include Amount and AmountInlVat and the page is published by default as workflowSalesDocumentLines which can access it from Power Bi and probably include workflowSalesDocuments, which are related to  Document Type AND DocumentNumber

Want to know more about Power BI? Learn Power BI from us.

Check out our Power BI Course to have a complete grip on Power BI concepts!