Create a new query from other table

[sebasjuniper1]

Hello

I need to launch a query to another database with the data obtained in another table.

Example:

1) Fill with SQL the Data Table

2) Create a new Table with column customer

Now I neeed to create a SQL query to another database and server with Customer in (COLUMN) the only idea the only idea I can think of is to pass it to ',' join. And then pass it as a parameter in an SQL IN

'9556','288'

Is there any other way?

Can you help me make a ',' and pass it by parameter?

I can't do a merge query since there is a lot of data

Thanks

[mwegener]

Hi @sebasjuniper1,

I would recommend Power Query.

I think, if the Power Query Query Folding is not able to combine the data on Source Layer, there will be no better way.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[sebasjuniper1]

Hi @mwegener 

Thanks for you reply

I don't understand why you tell me to use power query. What do you mean?

Thanks

[mwegener]

Hi @sebasjuniper1 ,

In my opinion, it is better to use rudimentary power queries than to generate technically complex SQL queries.

But you have found your solution. I wish you success. 🙂

[sebasjuniper1]

Hi! @mwegener 

Can you explain the better solution or a web when i can learn. 

I'm very interested to use "correctly" the power bi

Thanks

[mwegener]

Hi @sebasjuniper1 ,

If you want to merge data from two data sources, create one query per data source and merge them using the dialog box.

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-queries

Power Query should determine how the data could merge most efficiently and if necessary send filter values to the source.

https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[sebasjuniper1 · Accepted solution]

I found the solution here

https://community.powerbi.com/t5/Desktop/Pass-List-Value-through-SQL-Statement-without-Parameter/td-...

Thanks