Is there a character limit or certain invalid characters in column names in Power Query? I'm trying to rename some columns and getting an error,
Edit: As it turns out, it's giving me this error if I have any spaces in my column name. I am attempting to rename columns from a database table; is there a reason Power Query wouldn't be allowing me to do this?
Code:
Unexpected error: Length cannot be less than zero.
Parameter name: length
Details:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Length cannot be less than zero.
Parameter name: length ---> System.ArgumentOutOfRangeException: Length cannot be less than zero.
Parameter name: length ---> System.ArgumentOutOfRangeException: Length cannot be less than zero.
Parameter name: length
at System.String.Substring(Int32 startIndex, Int32 length)
at Microsoft.Mashup.Engine1.Library.Common.SyntaxTree.Sql.Alias.GetUniqueIdentifier(String identifier, String originalIdentifier, Int32 maxLength)
at Microsoft.Mashup.Engine1.Library.Common.SyntaxTree.Sql.Alias.AssignedAlias..ctor(String name, SqlSettings sqlSettings)
Edit: As it turns out, it's giving me this error if I have any spaces in my column name. I am attempting to rename columns from a database table; is there a reason Power Query wouldn't be allowing me to do this?
Last edited: