cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jjak
New Member

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!

2 REPLIES 2
jjak
New Member

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.

RicoZhou
Community Support
Community Support

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.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.