topic Re: Fetch Data from Matched column from Different table without importing complete Table -MySQL in Custom Visuals Development Discussion

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

Anonymous — Tue, 25 Feb 2020 07:08:06 GMT

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)

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

Cristian_Angyal — Fri, 17 Apr 2020 06:46:18 GMT

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