Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

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? 

1 Answer

0 votes
by (22.5k points)
edited by

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!

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Mar 3, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Dec 15, 2020 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...