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.
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 the quotes) in the name. While many other functions (I obviously didn't test them all), do work perfectly with a + in the columnname, this one does not.
The difference as far as I can tell is probably that most other functions that take one or more columnnames as an argument, demand the columnname(s) to be written in between double-quotes. The Table.InsertRows function however does not.
I.m.h.o. this is nothing less than a bug, since it never stated that (although maybe it is not considered to be very good programming practice) a '+' sign is not allowed in a column name.
My question therefore is: Can we either allow or disallow the '+' as part of a columnname, but please draw one line for all functions, as I can now change a part of my report again. I know for a fact that I will not use it again. 🙂
Thank you,
Best regards,
Niels
Solved! Go to Solution.
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
Dear @v-qiuyu-msft,
I just tried your suggestion and it works like a charm. I never knew it was possible to escape a columnname this way. I thought this was a reserved table syntax.
Thank you for your time and efforts!
Cheers,
Niels
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
Hi @C4YNelis,
I have sent a email to consult this issue internally, will update here once I get any information.
Best Regards,
Qiuyun Yu
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.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |