PowerQueryNet

Run Power Query M formula language from .NET (C#)

About

PowerQueryNet allows you to run M formulas commonly used in Power BI and Excel (aka Get & Transform) from any .NET application.

Download

Installer: PowerQueryNet.msi

Dependency: PowerQuerySdk.vsix 1.0.0.16

(Upon installation PowerQuerySdk.vsix must be in the same folder as PowerQueryNet.msi)

Samples: PowerQueryNet.Samples.zip

Hello, World!

1. Install PowerQueryNet.msi
2. From your .NET project, add a reference to PowerQueryNet.Client
3. Run the following:

var q = new Query { Formula = "let hw = \"Hello World\" in hw" };
var pq = new PowerQueryCommand();
var result = pq.Execute(q);
DataTable dt = result.DataTable;

Power Query App

Run queries in a standalone application

Build requirements

• Visual Studio 2015+

To build the Setup project, WiX Toolset must be installed.

Copyright

Copyright 2018

Licensed under the MIT License