Power BI connector: add native query support
还没有人认领这个 Issue。
评估
调研方向
The change belongs in the Power Query connector definition, adding SqlCapabilities with Sql92Translation set to "PassThrough" and a NativeQueryProperties record in the Publish record, following the linked Microsoft native-query SDK guide. Add a test that checks the generated SQL folds for later steps, then verify in Power BI Desktop in both Import and DirectQuery. Done means the Native query field appears, folding holds with EnableFolding = true, and the approval prompt works in both modes.
由索引模型根据 Issue 内容生成。
描述
Description
The connector has no way to enter a SQL statement in Get Data. Users who need a hand-written query must either create a view in Trino or fall back to Microsoft's generic ODBC connector, whose SQL statement field works with this driver but is Import-Mode-only and does not fold later steps.
Power Query's documented mechanism is Sql92Translation = "PassThrough" in SqlCapabilities plus a NativeQueryProperties record in the Publish record, which adds a Native query field to the dialog and, with EnableFolding = true, keeps subsequent steps folding: https://learn.microsoft.com/en-us/power-query/native-query-sdk
Tasks
- the .pq change
- a folding-contract test for the generated SQL
- a Power BI Desktop check in both Import and DirectQuery (DirectQuery behaviour with native queries is untested): Power BI asks the user to approve each native query; that is by design and stays.
- 主要语言
- Rust
- 星标
- 2
- 派生
- 0
- 平均合并
- 1 天 15 小时
- 30 天内合并 PR
- 3
环境准备
- 没有 Dockerfile 或 Docker Compose 文件
- 有 Pull Request 模板
- 阅读贡献指南
从这里开始
- 先读完整个 Issue，再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库，在一个分支上完成修改。
- 提交 Pull Request，并在描述里引用这个 Issue 编号。
stackabletech/stackable-odbc-trino 的其他 Issue
-
难度 1/5 1-3 小时 新手友好度 62/100
-
难度 1/5 1 小时以内 新手友好度 65/100
-
难度 2/5 1-3 小时 新手友好度 55/100
-
RUSTSEC-2026-0348: Brotli certificate decompression can allocate up to 1 GiB before authentication未关闭
难度 2/5 1-3 小时 新手友好度 50/100
-
难度 5/5 一周以上 新手友好度 15/100
查看 stackabletech/stackable-odbc-trino 的全部 Issue
相似的 Issue
-
难度 1/5 1 小时以内 新手友好度 88/100
pop-os/cosmic-comp#2956 ·
维护者通常 1 天内回复
-
难度 2/5 1-3 小时 新手友好度 85/100
libp2p/rust-libp2p#6694 ·
维护者通常 1 天内回复
-
难度 2/5 1-3 小时 新手友好度 78/100
EmbarkStudios/cargo-deny#910 ·
-
难度 2/5 1-3 小时 新手友好度 68/100
tursodatabase/turso#10054 ·
维护者通常 1 天内回复
-
build: Update rust version可能已有人在做 关联的 PR 仍在进行中或已合并。 未关闭dependencies
难度 2/5 1-3 小时 新手友好度 67/100
ibm-granite-community/granite-cli#229 ·
维护者通常 1 天内回复