Name of 'Attribute' cannot contain leading or trailing blank spaces or consist only of whitespace.

[Krishna09]

Hello all,

I am creating a datflow in dataverse. can anyone explain what this means? how to solve this error.

[PhilipTreacy]

Glad you got it figured out.

@dukeofrockville  @Krishna09 

Please mark my answer as the correct resolution so that others may benefit from learning how to solve this issue.

regards

Phil

[dukeofrockville]

Yes the end and beginning spaces are key and also on one of the columns there was a <cr/lf> character.  The dataflows are able to handle the spaces within the column name but not at the beginning or end or any special characters all of which are usually invisible

[PhilipTreacy]

@dukeofrockville @Krishna09 

Yes that's why I suggested you check for all white space like CR/LF, Tab etc.

Phil

[Krishna09]

@dukeofrockville ,

The columns in table have space after the column name. once I removed them, this error was resolved.

[dukeofrockville]

Dataflow automatically removes spaces but I manually did that too in the power query piece.  Further also added an alternate key.  Tried with a simple Excel file as well.  Nothing works. 

[PhilipTreacy]

Hi @dukeofrockville 

Need to see your data to assist any further.

As @Krishna09  confirmed, removing spaces in column names fixed the issue.  You certain you've removed all white space fromt he column names?  Not just the space character (ASCII #32) ?

regards

Phil

[Krishna09]

@PhilipTreacy This error has been resolved  for me. Thank you.

[PhilipTreacy]

Hi @Krishna09  @dukeofrockville 

Have you got any spaces in your column names?

See here Solved: Details: Name of 'CdmModel' cannot contain leading... - Power Platform Community (microsoft....

Regards

Phil

[dukeofrockville]

Thanks @PhilipTreacy  yes there actually blanks at the end of each column name!  Hard to find but resolved by removing them.

[dukeofrockville]

I am getting the same error message when loading any Excel sheet using DataFlow