Forum Discussion
Moving a query written in Word to Power Query
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
- Anonymous6 years ago
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
3 Replies
- AnonymousNot applicable
- amitchandak
Super User
theu1996 , Try on text pad
- AnonymousNot applicable
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