Forum Discussion

C4YNelis's avatar
C4YNelis
Icon for Advocate III rankAdvocate III
8 years ago
Solved

Table.InsertRows - Expression.SyntaxError: Invalid identifier.

After spending well over an hour chasing a very stubborn SyntaxError, I found out that the Table.InsertRows function in M Query does not work for columns containing a '+' (I mean the plus sign, not t...
Data Modeling
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi C4YNelis,

     

    The field name in a record literal has to be an identifier, and vanilla identifiers can't contain plus signs.

     

    However, you can include any characters you want by using an escaped identifier.

     

    [#"Customer+ID" = 2]

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi C4YNelis,

 

I have sent a email to consult this issue internally, will update here once I get any information. 

 

Best Regards,
Qiuyun Yu