Automatically Unpivoted Columns

[JoaoMachado]

Hi,

I've unpivoted some columns that I need to use in such a way. When I add new columns to the original datasource (Excel file) those will automatically get unpivoted as well, resulting in an error (OLE DB #value). Is it expected? Either way, how can I get around it?

Thank you,

João Machado

[v-haibl-msft · Accepted solution]

@JoaoMachado

This should be as expected. You can go to Query Editor - Advanced Editor to see the detailed power query. By default, if you click 'Unpivot Columns', it will use 'Table.UnpivotOtherColumns'. When new columns are added to the original datasource, this new column will also be unpivoted.

To get around it, you can select the column and click 'Unpivot Only Selected Columns'. The generated power query will be Table.Unpivot.

Best Regards,
Herbert

[JoaoMachado]

Hello, Herbert,

Thank you so very much for your help. It worked wonders!

Sincerely,

João Machado