Skip to main content

Power BI

Completed

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

Vote (29) 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/

Administrator on 14 Oct 2021 21:39:53

This is now complete, to learn more: https://www.youtube.com/watch?v=YWp4FKzIBxM

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

Olivier Travers 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