Forum Discussion

theu1996's avatar
theu1996
New Member
6 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    6 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi theu1996 ,

     

    You can try using notepad++.

     

    Regards,

    Harsh Nathani

  • Anonymous's avatar
    Anonymous
    Not 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