cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JoaoMachado Frequent Visitor
Frequent Visitor

Automatically Unpivoted Columns

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-haibl-msft
Microsoft

Re: Automatically Unpivoted Columns

@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.

 

Automatically Unpivoted Columns_1.jpg

 

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

 

Automatically Unpivoted Columns_2.jpg

 

Best Regards,
Herbert

View solution in original post

2 REPLIES 2
Microsoft v-haibl-msft
Microsoft

Re: Automatically Unpivoted Columns

@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.

 

Automatically Unpivoted Columns_1.jpg

 

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

 

Automatically Unpivoted Columns_2.jpg

 

Best Regards,
Herbert

View solution in original post

JoaoMachado Frequent Visitor
Frequent Visitor

Re: Automatically Unpivoted Columns

Hello, Herbert,

 

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

 

Sincerely,

João Machado

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,127)