有没有办法在 Excel 或 PowerBI 之外调用 PowerQuery/M? [英] Is there any way to invoke PowerQuery/M outside of Excel or PowerBI?

问题描述

我们的 BI 团队真的越来越喜欢Power Query ETL 工具在 Excel 和 Power BI 中使用.函数式语言 M/PowerQuery 非常实用，如果能能够在 PowerBI 的上下文之外使用.

Our BI team is really growing to like the Power Query ETL tool used within Excel and Power BI. The functional language M/PowerQuery has great utility and it would be nice to be able to utilize outside of the context of PowerBI.

是否有或有计划将M"作为独立模块公开，可从 c# 或 PowerShell 之类的形式调用?

Is there or are there plans for exposing "M" as a stand-alone module, callable form the likes of c# or PowerShell?

推荐答案

现在似乎可以通过 Power Query SDK.

这已经启用了诸如 PowerQueryNet 之类的项目，这些项目已经可以以编程方式执行 M PowerQuery 表达式.

This has enabled projects such as PowerQueryNet, which can already execute the M PowerQuery expressions programmatically.

尽管您应该记住，PowerQueryNet 的魔力是通过使用 未记录的 API 来实现的在商业设置中，可能会违反 Power BI/Power Query EULA.所以请谨慎行事.

Although you should keep in mind that the magic of PowerQueryNet is achieved through the use of undocumented APIs and in a commercial setup, may violate the Power BI / Power Query EULA. So tread with caution.

我目前正在努力将其放入一个 docker 容器中，该容器通过 REST 接收 M 并以请求的格式(JSON/CSV/XML)返回数据.

I'm currently working to put this into a docker container which receives M via REST and returns data in the format requested (JSON/CSV/XML).

如果有的话，所有这些都表明微软满足这个要求是多么容易.这也是对 Microsoft 软件开发资金不足的一个有趣见解，或者 Microsoft 很少意识到 Power BI/Power Query 的价值:它使精明的业务用户能够最了解他们的数据使用已安装在其计算机上的 Office 应用进行数据转换 - 巨大的进步.

If anything, all of this shows how easy it would be for Microsoft to satisfy this request. It's also an interesting insight into how under funded Microsoft software development might be, or how little Microsoft they realize the value of Power BI / Power Query: it enables savvy business users who know their data best to do hefty data transformations with Office apps already installed on their computers - a massive step forward.

这篇关于有没有办法在 Excel 或 PowerBI 之外调用 PowerQuery/M?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！