Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm usign this UnpivotOtherColumn command in Power Query in a step of a table data transformation:
= Table.UnpivotOtherColumns(#"Removed Columns", {"Id", "Name", "Date", "Version"}, "Attribute", "Value")
No Matter when my table contains data, but if I there are no data in it, I've got this error:
Expression.Error: The argument value isn't valid.
Details:
[List]
How could I avoid this error when the table is empty?
Thanks a lot in advance for any clue!
Solved! Go to Solution.
= if Table.IsEmpty(#"Removed Columns") then #table({"Id", "Name", "Date", "Version","Attribute", "Value"},{}) else Table.UnpivotOtherColumns(#"Removed Columns", {"Id", "Name", "Date", "Version"}, "Attribute", "Value")
= if Table.IsEmpty(#"Removed Columns") then #table({"Id", "Name", "Date", "Version","Attribute", "Value"},{}) else Table.UnpivotOtherColumns(#"Removed Columns", {"Id", "Name", "Date", "Version"}, "Attribute", "Value")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.