juansgr_'s avatar
juansgr_
New Member
22 days ago
Status:
Abandoned

Expose Power Query as a Standalone Runtime and Command-Line Interface (CLI)

Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...
Data Science
data warehouse
databases
power bi
miguel's avatar
miguel
Icon for Community Admin rankCommunity Admin
22 days ago
Status changed:
New
to
Abandoned

This is currently possible via the Dataflow REST API using the endpoint below:
Query Execution - Execute Query - REST API (Dataflow) | Microsoft Learn

You can also use the Data Factory MCP to make things a bit more straightforward in wiring the commands, but is fundamentally our path towards the problem / scenario that you've mentioned as to how we enable you to have the full runtime available without the UI or the need for another product (like Excel or Power BI) to be running alongside it.

Recent ideas