Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
I found the solution here
Thanks
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.
Hi @mwegener
Thanks for you reply
I don't understand why you tell me to use power query. What do you mean?
Thanks
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. 🙂
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
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.
I found the solution here
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |