Luke Walker on 15 Aug 2018 01:20:38
Add function to export Power Query queries to a file for import into either Power Pivot or another Power BI report.
- Comments (2)
RE: Export Power Query Connection File
This is a good idea, but here's a workaround:Firstly, if you don't need an exported file, you can skip the steps below, and copy-paste directly from one Power Query to another. However, if you need an exported file (for source control, sharing with co-workers, etc.), then keep reading.To export your queries to a file, follow these steps:Install Marcus Wegener'sExport2Dataflow External Tool in Power BI DesktopOpen the report file containing the queries you want to exportRun Export2Dataflow from the External Tools ribbon and save the resulting JSON fileYou now have a file containing all of the queries from your report.To import these queries into another Power Query window, follow these steps:Import the JSON file as a Dataflow in the Power BI web serviceOpen the new Dataflow for editingSelect the queries from the queries list on the left side, using Ctrl+Click or Shift+Click to multi-selectCopy the selected queries to your clipboard with Ctrl+C or by right-clicking on the selected queries and choosing Copy from the context menuOpen the Power Query window where you want to put the queries, click in the blank space in the queries list on the left side, then paste with Ctrl+V or by right-clicking on the selected list and choosing Paste from the context menuI hope this proves useful in the short term while we wait for the real thing.
RE: Export Power Query Connection File
This would also be great to add a bit of version control to the power bi, enabling to track changes in the more code-ish part of the report, instead of just keeping backup copies of different development stages of the report.