Forum Discussion

sebasjuniper1's avatar
sebasjuniper1
Regular Visitor
6 years ago
Solved

Create a new query from other table

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   ...
Need Help
sebasjuniper1's avatar
sebasjuniper1
Regular Visitor
6 years ago

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's avatar
mwegener
Most Valuable Professional
6 years ago

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.