Help with odata filter usage

[jjak]

Hello,

i am trying to get data from dynamics NAV via odata. I am able to retrieve data from our test system, but I have several questions regarding the usage of odata in power bi.

1. I need to get data from different odata web services (projects, work_orders, sales_orders and projectplan). The projects odata service  is already filtered and delivers round about 20-30 project numbers which should be a parameter for the calls of the other odata services. How can I achieve this?

If I simply get all data from the work_order oder sales_order odata service the call takes to way much time, so I want to filter the call in the odata url.

2. How can I call the odata feeds sequentially? First I need the project numbers, then decide for which project I want to get the other data and then call the next odata service with the correct filter applied. How can I do this? Or is it even possible?

best regards!

[jjak]

Thank you for your answer, but the offical blogs do not help here. I am already able to create the data source, but I do not know how to filter it dynamically based on values from another data source. The blogs do not answer that.

[v-rzhou-msft]

Hi @jjak ,

I hope the offical blogs could help you solve your issue.

For reference:

Using Dynamics NAV as a Power BI Data Source

Viewing List Data in Power BI Reports in Dynamics NAV

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.