PowerQueryNet

To use PowerQueryNet, download and install the MSI installer.

Important Dependency: You must download PowerQuerySdk.vsix (version 1.0.0.16) and place it in the same folder as PowerQueryNet.msi before running the installer. Failure to do this may result in an incomplete installation.

Download: https://github.com/gsimardnet/PowerQueryNet/releases/latest/download/PowerQueryNet.msi
Dependency: http://dakahn.gallery.vsassets.io/_apis/public/gallery/publisher/dakahn/extension/powerquerysdk/1.0.0.16/assetbyname/PowerQuerySdk.vsix

To verify your installation, create a simple M script and run it via the CLI.

1. Create a file named helloworld.pq with the following content:

let Source = "Hello, World!" in Source

2. Execute it in the Command Prompt:

pqnet helloworld.pq

To integrate Power Query execution into your C# application, add a reference to the PowerQueryNet.Client library.

You can use the Query class to define your M formula and the PowerQueryCommand class to execute it. The ExecuteOutputFlags property allows you to specify the desired output format (e.g., ExecuteOutputFlags.Csv).

var qry = new Query { Formula = "let hw = \"Hello World\" in hw" };
var pqc = new PowerQueryCommand() { ExecuteOutputFlags = ExecuteOutputFlags.Csv };
var result = pqc.Execute(qry);

PQNet is the Command Line Interface included with PowerQueryNet. It allows you to execute Power Query M formulas and export results to various formats or databases.

Export to file formats

You can export query results to csv, json, html, or xml using the -o flag.

pqnet "#Hello World.pq" -o json

Export to SQL Server

Use the -s flag to provide a connection string and the -t flag to specify the target table.

pqnet "#Hello World.pq" -s "Data Source=.\SQL2016;Initial Catalog=AdventureWorks2012;Integrated Security=SSPI" -t "dbo.HelloWorld"

Run queries from a Power BI (.pbix) file

You can extract results from a specific query within a .pbix file using the -o (output format) and -f (file path) flags.

pqnet MyReport.pbix Query1 -o csv -f result.csv

The PQNet CLI returns an exit code upon completion. A return value of 0 indicates success. Any non-zero value indicates an error occurred during execution.

if %ERRORLEVEL% EQU 0 (
    echo Success
) else (
    echo Exit Code is %errorlevel%
)