Power BI
CompletedCopy/paste M queries with dependencies from desktop apps into dataflows
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)
RE: Copy/paste M queries with dependencies from desktop apps into dataflows
This is now live:
https://www.youtube.com/watch?v=YWp4FKzIBxM