Help with odata filter usage

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!