Group By's "All Rows" does not quote columns identifiers, throwing "Syntax Error:Invalid identifier"

[Anonymous]

As the title says, when performing a Group By operation using the All Rows aggregate, Power Query does not quote column identifiers which contain invalid characters other than spaces (in my case it was parentheses).

This results in an Expression.SyntaxError error due to invalid identifiers being referenced by the automatically generated query step.

Here is an excerpt from the Group By step. You can see that the two columns were not escaped automatically, leading to a Syntax Error.

= Table.Group(#"Changed Type", {"FIN.TRANSACTION REFERENCE NUMBER"}, {{"Count", each Table.RowCount(_), type number}, {"Data", each _, type table [MCH.MERCHANT CATEGORY CODE (MCC)=text, ACC.ACCOUNT GROUP NAME(S)=text, /* other columns, removed for tidyness */]}})

Here is my adjusted code, which works:

= Table.Group(#"Changed Type", {"FIN.TRANSACTION REFERENCE NUMBER"}, {{"Count", each Table.RowCount(_), type number}, {"Data", each _, type table [#"MCH.MERCHANT CATEGORY CODE (MCC)"=text, #"ACC.ACCOUNT GROUP NAME(S)"=text, /* other columns, removed for tidyness */]}})

I don't know what is the parsing logic for automatically escaping column names, but it is evidently missing this perticular case.

Thanks!

GL

[MFelix]

Hi @Anonymous ,

I'm on the May 2019 version, and try to make a small table with the same name as you refer on your post and the grouping got done without any errors, making automatically the expression similar to your second expression.

What is the version you are using and how did you make the group by? Did you write the code or did you use the grouping option?

Regards,

MFelix