Can any combination of xlsx/csv be combined in one table?

[UsePowerBI]

Hello!

Is it possible to combine different xlsx/csv in one table when there may be many worksheets with very different data (i.e. no common columns)?

I think the Combine and Load function tries to either merge or append the tables which may not be possible if the data is very different.

Thanks!

[amitchandak]

@UsePowerBI , depending one data, append and merge can help

Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Sometime we create common dimensions and analyze them together

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...