Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AlmarBiter
New Member

Power Query Table.UnpivotColumns Expression.Error

Hi Guys,

 

Need your help. I was encountering an error when using the Table.UnpivotColumns.

AlmarBiter_0-1745066818903.png

 

Advance Editor

AlmarBiter_1-1745067142189.png

 

I try to fix it until I came up to try simple code like this  and I encounter the same error.

let
    Source = #table({"Category", "Value1", "Value2"}, {{"A", 1, 2}, {"B", 3, 4}}),
    Unpivoted = Table.UnpivotColumns(Source, {"Value1", "Value2"}, "Attribute", "Value")
in
    Unpivoted

AlmarBiter_2-1745067573734.png


Appreciate your any feedback. Thank you

3 ACCEPTED SOLUTIONS
SundarRaj
Super User
Super User

Hi @AlmarBiter , The error says it is a formula error: Use Table.Unpivot() or Table.UnpivotOtherColumns() as per your need. Thanks!

Sundar Rajagopalan

View solution in original post

krishnakanth240
Regular Visitor

Hi @AlmarBiter ,

Okay, Can you replace with 'Table.UnpivotOtherColumns' instead of Table.UnpivotColumns. This function unpivots all columns except the ones specified, which might work for your case.

 

Could you please check and confirm? Thank you

View solution in original post

ronrsnfld
Super User
Super User

There is no function named Table.UnpivotColumns. Hence, your error.

View solution in original post

5 REPLIES 5
AlmarBiter
New Member

Thanks for your help. My earlier reference included the Table.UnpivotColumns function, but after reviewing the latest Power Query documentation, it appears this function is no longer available.

ronrsnfld
Super User
Super User

There is no function named Table.UnpivotColumns. Hence, your error.

krishnakanth240
Regular Visitor

Hi @AlmarBiter ,

Okay, Can you replace with 'Table.UnpivotOtherColumns' instead of Table.UnpivotColumns. This function unpivots all columns except the ones specified, which might work for your case.

 

Could you please check and confirm? Thank you

I'm now using the Table.UnpivotOtherColumns and it's working. Thanks for the help

SundarRaj
Super User
Super User

Hi @AlmarBiter , The error says it is a formula error: Use Table.Unpivot() or Table.UnpivotOtherColumns() as per your need. Thanks!

Sundar Rajagopalan

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors