Skip to main content

Copy/paste M queries with dependencies from desktop apps into dataflows


Power Query, whether in Excel Desktop, Power BI Desktop, or Visual Studio, lets you copy/paste a query back and forth between query panes, and that single pasting will carry over all dependencies (if any), i.e. functions, parameters, and nested queries (via Combine or Append). This makes it very ...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Under Review

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


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. ...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
New