Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
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
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.