Skip to main content

Power BI

Needs Votes

Make code generated by Power Query UI less dependent on hardcoded values

Vote (11) Share
Olivier Travers's profile image

Olivier Travers on 07 Apr 2019 21:51:31

All the code generated using the Power Query UI is so literal, it feels like I'm interacting with a dumb kid. If I'm selecting all columns and, say, trimming them, why hard code all the column names? It makes code hard to re-use and brittle, which generates a lot of menial code editing overhead.

Instead I would like PQ to try and generate more generic code. I'm sure combining soft coding with code generation is a hard problem, but this would have so much more impact on the productivity of Power Query developers than sinking resources into yet another sentiment analysis AI solution that hardly anyone uses outside of demos...