2 ms·
> I'll take plain text over WYSIWYG any day, thanks. I couldn't agree more. It's a bit convoluted, but one thing you can do is write code in plain text files,
by dkbrk 4y ago
> I'll take plain text over WYSIWYG any day, thanks.
I couldn't agree more. It's a bit convoluted, but one thing you can do is write code in plain text files, in the Power Query M language, and load it using a combination of Folder.Files [0], BinaryFormat.Text [1], and Expression.Evaluate [2] (in the #shared environment).
On the downside, everything is no longer self-contained in the workbook. On the upside, everything is no longer self-contained in the workbook, and you can actually, like, check the code into git.
[0]: https://docs.microsoft.com/en-us/powerquery-m/folder-files https://docs.microsoft.com/en-us/powerquery-m/folder-files
[1]: https://docs.microsoft.com/en-us/powerquery-m/binaryformat-text https://docs.microsoft.com/en-us/powerquery-m/binaryformat-t...
[2]: https://docs.microsoft.com/en-us/powerquery-m/expression-evaluate https://docs.microsoft.com/en-us/powerquery-m/expression-eva...