Moving a query written in Word to Power Query

[theu1996]

I had to write a long conditional column argument and did so in Word since it would cause Power BI to run out of memory on my computer if I did it all in there. When I copy and paste it into the Add Column pop-up, it will not recognize the text as valid due to the " not being the right one. I cannot go through and replace them all in BI without crashing the program, and have not been able to successfully use Find and Replace to replace Word's " with the Power Query accepted one. Is there an easy way to change the quotation marks?

Thanks

[v-jayw-msft · Accepted solution]

Hi @theu1996 ,

The unicode in Word and Power BI are different. Paste the code into Text or Excel and replace the quotation marks.

Best Regards,

Jay

[amitchandak]

@theu1996 , Try on text pad

[harshnathani]

Hi @theu1996 ,

You can try using notepad++.

Regards,

Harsh Nathani