Join using Odata or Power Query to fetch Daat from D365 f&O

(0) Share

Report

Posted on by aasghar

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?

All responses (2)

Answers (1)

aasghar 67 on at

Like (0)

Report

RE: Join using Odata or Power Query to fetch Daat from D365 f&O

thanks Judy...
Verified answer

huijij 19,811 on at

Like (0)

Report

RE: Join using Odata or Power Query to fetch Daat from D365 f&O

Hi aasghar,

As far as I know, OData does not support such operations, you can do some customization, you can fish out the data of the first table, and then compare it with the data of the second table.