Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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)

 

 

1 Reply

  • Cristian_Angyal's avatar
    Cristian_Angyal
    Most Valuable Professional
    6 years ago

    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