Hello, i need to understand, how i can i fetch data from below 2 Entities in Microsoft D365 F&O to Power BI Queries or using Odata?
1. ProductionOrderHeaders
2. ProductionBillofMaterialLines
i need to have data from table 1 with sepcific filters like ProdStatus = 'Startedup'. this i managed to get but issue is how i setup the join to second table to get data from that table based on the filtered data in table one. means only records from ProductionBill of materialLines where the productionOrderNumber Associated with these records have ProdStatus = 'startedup' which is field in first table an dnot in this table.
anyway i can fetch daat from 1st table than fetch dat from 2nd table but using 1st table column as parameter to filter?
Or is there a way to Join Tables?
