Passing values from other querys value to another query (different databases)

[esaesa]

Hi,

I have a query from oracle database:
select order from orderno

results for instance
1234
1763
1452

Then I would like to pass those values from column 'order' to MS SQL query:
select number from numberorder where number in ('--values from oracle query')

Should I do this with parameters, but how?

[v-yuta-msft]

Hi esaesa,

Query Parameter can meet your requirement, please refer to:

http://biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-paramete...

Regards,

Jimmy Tao