Forum Discussion
Pasting code back into Power Query, double quotation marks not pasting properly
So I was creating a new custom column, based on one I created in another source, and I took the original code into Word for easy finding/replacing of certain pieces to create the new one. When pasting it back into the prompt in Power BI, I noticed the pieces I replaced with quotation marks were pasted as what seems to be specific opening and closing quotation marks, different from the ones used in the formula editor. This is causing an 'invalid identifier' error to occur.
I tried copying one of the 'correct' quotation marks and using the find/replace to swap out the 'incorrect' ones but no luck. My curiousity is wondering if there's a reason for this but ultimately, is there a workaround for this? I couldn't find anything about this online...
If you want to write your code with another program, use notepad or Visual Studio Code with M Language installed (intelliSense included!):
8 Replies
So because I made the changes in Word, when I paste the code into there I still run into the same issue. Here's what I'm seeing in the Advanced Editor. I can manually replace them, but we're talking tens of thousands at least haha. I should have provided a screenshot in the original post, sorry about that.
If you want to write your code with another program, use notepad or Visual Studio Code with M Language installed (intelliSense included!):
The same thing happen for me in another case, in such situation when I write quotation it is different than normal one, so I press Ctrl+Z just after that and it is channged into the normal one, i think it is because of some setting in the word, specially for me which some time use language other than english
