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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Can a union table merge another table?

I can't find a way to do that. First I have to load those tables, but my union table didn't show up in my pane.

 

 

2 REPLIES 2
TomMartens
Super User
Super User

Hey @Anonymous ,

 

the simple answer - yes you can union two or more tables using Power Query, in Power Query this operation is called Append, then you can Merge a different table.

But without any information what you are exactly trying to do, I can not provide more guidance.

Consider creating sample data, e.g., one Excel file with multiple sheets, where each sheet represents one of the tables. Upload the xlxs to OneDrive, Google Drive, or Dropbox and share the link.

 

Desribe the expecte result based on the sample data you provide. Ideally one sheet in the Excel file represents the expected result. Be explicit about rules, e.g., how the tables are merged.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Anonymous
Not applicable

Hi, Tom,

 

Thank you very much for your reply. But, how do we start it?

At first, we choose Home >>Transform data >>Transform data, at this time, my union table is invisible. I choose the other table first, but in the selection area, I can't find my union table.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors