Skip to main content

Power BI

Under Review

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

Vote (28) Share
Olivier Travers's profile image

Olivier Travers on 04 Dec 2018 23:26:55

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 easy to migrate PQ solutions from Excel to PBI to SSAS/AAS.

My suggestion is to add a Paste action in the Power Query Online query pane, with the same smart behavior as in the desktop apps.

See this if you're not familiar with the desktop behavior I'm talking about:
https://blog.crossjoin.co.uk/2017/02/25/exporting-your-queries-m-code-from-power-query-and-power-bi-using-copypaste/

Comments (1)
Olivier Travers's profile image Profile Picture

40502e40 76ce-4f42-b63d-31ddf675aac9 on 06 Jul 2020 00:15:18

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

This is now live:
https://www.youtube.com/watch?v=YWp4FKzIBxM