Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Is it possible to merge table columns before expanding table columns in a Folder import?

I have a scenario where I am combining multiple tables in a workbook, but each table has a few columns that are inconsistently titled. I need to combine them all into a single table, but I cannot do so effectively as the inconsistent column titles result in separate columns (e.g., Warranty and Warr appear as two separate columns). I am wondering if it possible for me to create a separate table that lists a column name/correct column pairing (as shown below) and have Power BI merge the source data columns based on this before expanding the data in those columns:


Column        Correct Column

Warr                 Warranty


For example, when the tables in the SourceData table are expanded, PBI first checks to see if Warr exists in the table. If it does, then it changes the column name to Warranty so the appended data displays correctly.

Community Support
Community Support

Re: Is it possible to merge table columns before expanding table columns in a Folder import?

Hi @dehmos27 

Do you have tables as below?


You want to merge two tables to get the following table, right?

id correct column inter
1 warranty sd
2 werranty d


Best Regards


Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.



Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors