Forum Discussion
Vendor Aging Report
Hey deeksha
ODATA is "just" an interface to a data source, you have to consult the owner of the data source, where you can find all the fields you need. Maybe it will become necessary to retrieve more than one table / define more than ODATA connection and finally join the tables accordingly inside Power BI.
Regards,
Tom
I have to create a vendor aging report in power bi just like the one in d365, and I am trying to get the data using OData but i don't know from which data entity or tables I can get the values like account number, vendor name, group and their balances as of different months, this I want to know, from which table I will get these fields and values.
- There are a number of datasets you can get from different marketplaces, here is a sample source https://docs.microsoft.com/en-us/power-bi/sample-datasets.
Sorry, maybe you are not getting my question, I need the name of the data entity or table where I can the vendor aging report fields and values.
- I think am tracking now your data source is D365 right? If that's correct your tables will be customer Details table
https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/customer-aging-report-custagingreport