Fetch Data from Matched column from Different table without importing complete Table -MySQL

[Anonymous]

Hi, 

Please help me with this

I am importing data from two different table-based on Mysql query, Table-A contains value  Eg: order_ids (Query output)

power_query:  select order_ids from order_table

                       where order_created_on > current_date()

Output:  4001342,

              4001331,

              4000123

Now I want to import data from values corresponding to order_ids  which already imported from Table A

**how to use below  query in power_bi: (Number vary based on the previous query while running)

select * from shipments

where order_ids in ( 4001342,4001331,4000123)

[Cristian_Angyal]

Hello @Anonymous ,

Best option (and recommended) is to push this type of work as close as possible to the datasource (database here) (for example you could create a view with the same logic and then connect to that view.)

If this is not possible due to various reasons I would make a query to get the exact output needed for the WHERE CLAUSE (4001342,4001331,4000123) and then use it "as is" in the second query. Caution: you need to be careful with the data privacy settings.

If you liked my solution please give it a thumbs up 👍. 

If I did answer your question please mark my post as a solution ✅.

Thank you !

Cristian