This is an automated email from the ASF dual-hosted git repository.
catpineapple pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 537b0863413 [powerbi](docs) powerbi use doris connecter (#2408)
537b0863413 is described below
commit 537b08634139ea3664508d315675e1f91d37ad74
Author: catpineapple <catpineapple1...@gmail.com>
AuthorDate: Fri May 30 14:46:18 2025 +0800
[powerbi](docs) powerbi use doris connecter (#2408)
## Versions
- [x] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/ecosystem/bi/powerbi.md | 27 +++++++++--------
.../current/ecosystem/bi/powerbi.md | 32 +++++++++++----------
static/images/powerbi/bi-powerbi-en-3-new.png | Bin 0 -> 46375 bytes
static/images/powerbi/bi-powerbi-en-4-new.png | Bin 0 -> 27390 bytes
static/images/powerbi/bi-powerbi-en-5-new.png | Bin 0 -> 18010 bytes
5 files changed, 32 insertions(+), 27 deletions(-)
diff --git a/docs/ecosystem/bi/powerbi.md b/docs/ecosystem/bi/powerbi.md
index a84347b2b77..2ad4e5c1513 100644
--- a/docs/ecosystem/bi/powerbi.md
+++ b/docs/ecosystem/bi/powerbi.md
@@ -28,20 +28,23 @@ under the License.
Power BI is a collection of software services and application connectors that
can connect to multiple data sources, including Excel, SQL Server, Azure,
Google Analytics, etc., so that users can easily consolidate and clean their
data. With Power BI's data modeling, users can create relational models, data
analysis expressions, and data relationships to support advanced data analysis
and visualization. Power BI offers a wealth of visualization options, including
ICONS, maps, dashboards, a [...]
-Apache Doris is highly compatible with MySQL protocol and can be connected to
Power BI through MySQL Driver. At present, internal data modeling, data query
and visualization processing of Apache Doris have been officially supported in
Power BI.
+The Apache Doris community provides a Power BI DirectQuery custom connector
based on MySQL ODBC, which supports Apache Doris's internal data modeling, data
query, and visualization processing.
## Precondition
-If you do not have Power BI desktop installed, you can download it from
https://www.microsoft.com/en-us/power-platform/products/power-bi/desktop
+- If you don't have Power BI Desktop installed, you can visit
[here](https://www.microsoft.com/zh-cn/power-platform/products/power-bi/desktop)
to download and install Power BI.
+- You need to obtain the
[power-bi-doris](https://github.com/velodb/power-bi-doris/blob/master/Doris.mez)
custom connector.
+- If you don't have Mysql ODBC installed, you need to download and install
[Mysql ODBC](https://downloads.mysql.com/archives/c-odbc/) and configure it.
-## Connector configuration of Power BI and Doris
:::info Note
-Currently verified using MySQL JDBC Connector version 8.0.26
+Use MySQL ODBC Driver 5.3
:::
-Download and installation MySQL Connector
-Download link: https://downloads.mysql.com/archives/c-net/. Select version
8.0.26. There are incompatibilities in higher versions
+## Power BI and Doris custom connector configuration
+1. Refer to the path here: `\Power BI Desktop\Custom Connectors folder`, place
the `Doris.mez` custom connector file (if the path does not exist, create it
manually as needed).
+2. In Power BI Desktop, select `File` > `Options and settings` > `Options` >
`Security`, under `Data Extensions`, check `(Not Recommended) Allow any
extension to load without validation or warning`.
+3. Select `ok` and restart Power BI Desktop.
## Load data locally and create models
@@ -50,17 +53,17 @@ Download link: https://downloads.mysql.com/archives/c-net/.
Select version 8.0.2
-3. Click get data. In the dialog box that is displayed, select MySQL database.
+3. Click Get Data and select the Doris database in the pop-up window.
- 
+ 
-4. Configure the database connection information and enter ip:port in the
server text box. The default port number for Doris is 9030.
+4. Configure the database connection information and enter host:port in the
server input box. The default port number of Doris is 9030
- 
+ 
-5. Click OK in the previous step and select "Database" in the new connection
window to connect, and fill in the connection information of Doris in the
username and password.
+5. After clicking OK in the previous step, fill in Doris’ connection
information in the new connection window.
- 
+ 
6. Load the selected table to the Power BI Desktop
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/powerbi.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/powerbi.md
index 1d09bd96d81..686381c4dbf 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/powerbi.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/powerbi.md
@@ -1,7 +1,7 @@
---
{
- "title": "Power BI",
- "language": "zh-CN"
+ "title": "Power BI",
+ "language": "zh-CN"
}
---
@@ -28,21 +28,23 @@ under the License.
Power BI 是软件服务、应用连接器的集合，其可以连接到多种数据源，包括 Excel、SQL Server、Azure、Google Analytics
等，以便用户可以轻松得整合和清洗数据。通过 Power BI
的数据建模，用户可以创建关系模型、数据分析表达式和数据关系，以支持高级的数据分析和可视化。Power BI
提供了丰富的可视化选项，包括图标、地图、仪表盘和自定义可视化工具，以帮助用户更直观地理解数据。
-Apache Doris 高度兼容 MySQL 协议，可以通过 MySQL 驱动器连接 Power BI，当前 Power BI 中已经正式支持了
Apache Doris 的内部数据建模以及数据查询与可视化处理。
+Apache Doris 社区提供了基于 Mysql ODBC 的 Power BI DirectQuery 自定义连接器，支持了 Apache Doris
的内部数据建模以及数据查询与可视化处理。
## 前置条件
-未安装 Power BI Desktop 可以访问
https://www.microsoft.com/zh-cn/power-platform/products/power-bi/desktop 下载安装
Power BI。
-
-## Power BI 与 Doris 的 Connector 配置
+- 未安装 Power BI Desktop 可以访问
[此处](https://www.microsoft.com/zh-cn/power-platform/products/power-bi/desktop)，下载安装
Power BI。
+- 需要获取
[power-bi-doris](https://github.com/velodb/power-bi-doris/blob/master/Doris.mez)
自定义连接器。
+- 未安装 Mysql ODBC 需要下载安装 [Mysql
ODBC](https://downloads.mysql.com/archives/c-odbc/)，并配置 。
:::info Note
-选择 8.0.26 版本的 MySQL JDBC Connector
+选择 MySQL ODBC Driver 5.3
:::
-MySQL Connector 下载
+## Power BI 与 Doris 的自定义连接器配置
-下载链接：https://downloads.mysql.com/archives/c-net/
+1. 参考此处路径：`\Power BI Desktop\Custom Connectors folder`，放置 `Doris.mez`
自定义连接器文件（如果路径不存在，按需手动创建）。
+2. 在 Power BI Desktop 中，选择 `File` > `Options and settings` > `Options` >
`Security`，在 `Data Extensions` 下，勾选 `(Not Recommended) Allow any extension to
load without validation or warning` 。
+3. 选择 `ok` ，然后重启 Power BI Desktop。
## 本地加载数据与创建模型
@@ -51,17 +53,17 @@ MySQL Connector 下载
-3. 点击获取数据，在弹出窗口中选择 MySQL 数据库
+3. 点击获取数据，在弹出窗口中选择 Doris 数据库
- 
+ 
-4. 配置数据库连接信息，在服务器输入框中输入 ip:port。Doris 默认的端口号为 9030
+4. 配置数据库连接信息，在服务器输入框中输入 host:port。Doris 默认的端口号为 9030
- 
+ 
-5. 上一步点击确定后在新的连接窗口处选择"数据库"连接，并在用户名与密码处填写 Doris 的连接信息。
+5. 上一步点击确定后在新的连接窗口处填写 Doris 的连接信息。
- 
+ 
6. 加载选中的表，使其表中数据至 Power BI Desktop
diff --git a/static/images/powerbi/bi-powerbi-en-3-new.png
b/static/images/powerbi/bi-powerbi-en-3-new.png
new file mode 100644
index 00000000000..d55c4781ff6
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-3-new.png
differ
diff --git a/static/images/powerbi/bi-powerbi-en-4-new.png
b/static/images/powerbi/bi-powerbi-en-4-new.png
new file mode 100644
index 00000000000..1e4a2e92a74
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-4-new.png
differ
diff --git a/static/images/powerbi/bi-powerbi-en-5-new.png
b/static/images/powerbi/bi-powerbi-en-5-new.png
new file mode 100644
index 00000000000..393479f2a0a
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-5-new.png
differ
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
