Notifications
Announcements
No record found.
Hello Every one
I want to make report for sales by power bi desktop .I used "Odata Feed " type connection when I connect there are a lot of data appear but tables I need not appear .
I need these tables:
CustInvoceJour
and
CustInvoceTrans
I need most of fields in these table to build report .
can any one help me to how to connect these tables or instead table with a same fields , or there other type we can connect Dynamic 365 FO tables .
Thanks for all.
Hi Khaled,
Using the Odata feed, you will get access to the Data entities exposed by D365 F&O. In your case, you can try the entities -
1. SalesInvoiceHeaderV2Entity (SalesInvoiceHeadersV2) - This has CustInvoiceJour as the primary data source.
2. SalesInvoiceLineV2Entity (SalesInvoiceV2Lines) - This has CustInvoiceTrans as the primary data source.
However, since you are developing a Power BI report, BYOD might be a better option. Please check here for details.
Thanks for your replay
It checked this table but a lot of fields not in this , now who to add missing fields to "alesInvoiceLineV2Entity"
You can create an extension to this data entity and add the new fields. You can check this post on how to get this done.
Is this customization (need a developer ) or can do it direct in production 365 cloudy Environment.
Regrading this option BYOD : can I create this database with need tables only or should create full database , also is this option need Azure subscription or D365FO subscription enough ?
You will need a developer to do this on a Dev environment and then promote it to the Prod environment on cloud.
For BYOD, you will need an Azure subscription as you will need to create an Azure SQL database. You can then choose the entities you need that will be created in the Azure SQL DB. You can check the steps in this post.
Hello ,
I am trying to connect this data entity "SalesInvoiceV2Lines" , result appear in query
but when I want to apply it this message appear :
Apply query changes
SalesInvoiceV2Lines
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
Hi Gunjan ,
I connected to power bi with D365FO , but only one company sales invoice appear , other company nothing appear , is there any setting or option should be set to allow company data to go to power Bi ?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 611 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
