Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Help managing queries



I thnk I'm going to get crazy with a, for sure, easy question.


I have two queries I need to combine. We manage shops, sells and client surveys, but one of our shop uses a diferent survey system, so the data needs to be joined. We also use a global sale ID number for all the shops. The schema is quite this:


Table 1:

Sell ID // Shop // Channel // Survey response // Survey comments // and many other fields that are not in table 2.


In table 2 we have the same fields. Sell ID always matches with Table 1 (it's also registered there), Shop is always the city of the shop, it is common in Table 2, but in Table 1 we have another cities, Channel is if the sell was at the shop or online (that info is also in Table 1).

and many other fields, like prize, etc. In the table 2 we have a similar schema, but with less columns.


The thing is that Sell ID number can be in both tables (in fact, they are, all their sells are registered with that format). Information of both tables only changes in the survey fields, which is empty in the table 1. I need to choose the Sell ID, for example, and when it matches, pass the information of the Survey columns of the table 2 to the table 1. But only these 2 fields, keeping all the others like they are.


I tried to merge with all kind of combinations, and I could get the survey info in the merged query, but in exchange I lose all the other fields. of the table 1.


Thanks in advance for your help.

Community Support
Community Support

Hi @Anonymous 


Did you try Merge queries feature? In the table 1, click Merge queries, then merge the table 2 to the table 1. You can select one or multiple columns as matching columns. This will not lose other fields of the table 1. 


Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Not applicable

Yes, thank you very much. I had been touching this, but as I am still very new, I was doing it bad. 🙂



Super User
Super User

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors