Forum Discussion
Create a new query from other table
I found the solution here
Thanks
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.