microsoft / vscode-powerquery

Visual Studio Code extension for Power Query / M.
MIT License
86 stars 16 forks source link

powerquery.extractDataflowDocument - command to extract document from dataflow.json #184

Closed mattmasson closed 1 year ago

mattmasson commented 1 year ago

This change adds a helper command that extracts and formats the M document contained within the dataflow.json definition you'd get from the Power BI UX (export .json).

Steps:

  1. Export .json for dataflow definition from Power BI
  2. Save file locally
  3. Open dataflow.json file in VS Code editor
  4. Ctrl+Shift+P to bring up commands
  5. Run powerquery: Extract document from dataflow.json image

A new text editor should appear with the formatted M document.