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 e27a4e42e3e powerbi example (#3083)
e27a4e42e3e is described below
commit e27a4e42e3ec436e64b44fdac5d8ff8d3ffab9e9
Author: catpineapple <[email protected]>
AuthorDate: Wed Nov 12 18:17:06 2025 +0800
powerbi example (#3083)
## Versions
- [ ] dev
- [ ] 4.x
- [ ] 3.x
- [ ] 2.1
## Languages
- [ ] Chinese
- [ ] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/ecosystem/bi/powerbi.md | 48 +++++++++++++++++---
.../current/ecosystem/bi/powerbi.md | 50 ++++++++++++++++++---
.../version-3.x/ecosystem/bi/powerbi.md | 48 +++++++++++++++++---
.../powerbi/CfGWb6oaYoj4LyxpPIGcz3Binzb.png | Bin 0 -> 263698 bytes
.../powerbi/FZL5b2kJcoifIaxI7Eocpak7nvf.png | Bin 0 -> 222452 bytes
.../powerbi/J7xObwqSYoTdTQx3hjgcAjQznS5.png | Bin 129491 -> 506888 bytes
.../powerbi/JxpJbihDHoHGwixjWQScNyxvn4e.png | Bin 0 -> 261137 bytes
.../powerbi/LomhbQTPPoZr58xp8f3cxcTen8d.png | Bin 0 -> 92346 bytes
.../powerbi/MB34bks6woK3mDx0eVccivKEngc.png | Bin 0 -> 260995 bytes
.../powerbi/UxL2b1OV2or1LhxZjHsc0JG7ntb.png | Bin 0 -> 98608 bytes
.../powerbi/V7PsbP3oKoJpLjxK5HdcPsnLnKf.png | Bin 0 -> 201775 bytes
...deUwnAe.png => WozGbmqAOoP2mqxq2NmcJRFyntc.png} | Bin
versioned_docs/version-3.x/ecosystem/bi/powerbi.md | 48 +++++++++++++++++---
13 files changed, 172 insertions(+), 22 deletions(-)
diff --git a/docs/ecosystem/bi/powerbi.md b/docs/ecosystem/bi/powerbi.md
index 9a7f9cea5b9..a3f52c9433b 100644
--- a/docs/ecosystem/bi/powerbi.md
+++ b/docs/ecosystem/bi/powerbi.md
@@ -136,14 +136,52 @@ Finally, you should see the databases and tables in the
Navigator view. Select t
-After the import is complete, your Doris data should be accessible in Power BI
as usual.
+After the import is complete, your Doris data should be accessible in Power BI
as usual, Configure the required statistical compass.
-Configure the required statistical compass
+## Building Visualizations in Power BI
-
+We've chosen TPC-H data as our data source. For instructions on building a
Doris TPC-H data source, refer to [this document](../../benchmark/tpch).
+Now that we've configured the Doris data source in Power BI, let's visualize
the data...
-Save the created statistical compass locally
+Suppose we need to know the order revenue statistics across different regions.
We'll build a dashboard based on this requirement.
-
+1. First, create the table model relationships. Click Model view.
+
+
+
+2. Drag and drop to place these four tables on the same screen as needed, and
then drag and drop the related fields.
+
+
+
+
+
+The relationships between the four tables are as follows:
+
+- **customer** ：c_nationkey -- **nation** : n_nationkey
+- **customer** ：c_custkey -- **orders** : o_custkey
+- **nation** : n_regionkey -- **region** : r_regionkey
+
+3. The results after association are as follows:
+
+
+
+4. Return to the Report view workbench and build the dashboard.
+5. Drag the `o_totalprice` field from the `orders` table to the dashboard.
+
+
+
+6. Drag the `r_name` field from the `region` table to column X.
+
+
+
+7. You should now have the expected dashboard content.
+
+
+
+8. Click the save button in the upper left corner of the workbench to save the
created statistical compass to your local machine.
+
+
+
+At this point, you have successfully connected Power BI to Apache Doris and
implemented data analysis and dashboard creation.
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 412cad01f3f..a436d7378c4 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"
}
---
@@ -136,16 +136,52 @@ Microsoft Power BI 可以从 Apache Doris 查询或加载到内存数据。
-导入完成后，您的 Doris 数据应在 Power BI 中如常访问。
+导入完成后，您的 Doris 数据应在 Power BI 中如常访问，配置需要的统计罗盘 。
-配置需要的统计罗盘
+## 在 Power BI 中构建可视化
-
+我们选择 TPC-H 数据作为数据源，Doris TPC-H 数据源构建方式参考[此文档](../../benchmark/tpch)
+现在我们在 Power BI 中配置了 Doris 数据源，让我们可视化数据...
-把创建好的统计罗盘保存至本地
+假设我们需要知道在各个地区之间的订单营收统计，接下来按照此需求进行看板构建
-
+1. 首先进行表模型关系的创建 ，点击 Model view
+
+2. 通过按需拖拽，将这四张表放置在同一屏幕下，然后进行关联字段的拖拽
+
+
+
+
+
+四张表关联关系如下：
+
+- **customer** ：c_nationkey -- **nation** : n_nationkey
+- **customer** ：c_custkey -- **orders** : o_custkey
+- **nation** : n_regionkey -- **region** : r_regionkey
+
+3. 关联后结果如下：
+
+
+
+4. 返回 Report view 工作台，进行仪表盘构建。
+5. 将 orders 表中的 o_totalprice 拖拽到仪表盘
+
+
+
+6. 将 region 表中的 r_name 拖拽到 X 列
+
+
+
+7. 现在得到预期看板内容
+
+
+
+8. 点击工作台左上角保存按钮，把创建好的统计罗盘保存至本地
+
+
+
+至此，已经成功将 Power BI 连接到 Apache Doris，并实现了数据分析和可视化看板制作。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/powerbi.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/powerbi.md
index 6698a6556e3..f4d167d9027 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/powerbi.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/powerbi.md
@@ -136,14 +136,52 @@ Microsoft Power BI 可以从 Apache Doris 查询或加载到内存数据。
-导入完成后，您的 Doris 数据应在 Power BI 中如常访问。
+导入完成后，您的 Doris 数据应在 Power BI 中如常访问，配置需要的统计罗盘 。
-配置需要的统计罗盘
+## 在 Power BI 中构建可视化
-
+我们选择 TPC-H 数据作为数据源，Doris TPC-H 数据源构建方式参考[此文档](../../benchmark/tpch)
+现在我们在 Power BI 中配置了 Doris 数据源，让我们可视化数据...
-把创建好的统计罗盘保存至本地
+假设我们需要知道在各个地区之间的订单营收统计，接下来按照此需求进行看板构建
-
+1. 首先进行表模型关系的创建 ，点击 Model view
+
+
+
+2. 通过按需拖拽，将这四张表放置在同一屏幕下，然后进行关联字段的拖拽
+
+
+
+
+
+四张表关联关系如下：
+
+- **customer** ：c_nationkey -- **nation** : n_nationkey
+- **customer** ：c_custkey -- **orders** : o_custkey
+- **nation** : n_regionkey -- **region** : r_regionkey
+
+3. 关联后结果如下：
+
+
+
+4. 返回 Report view 工作台，进行仪表盘构建。
+5. 将 orders 表中的 o_totalprice 拖拽到仪表盘
+
+
+
+6. 将 region 表中的 r_name 拖拽到 X 列
+
+
+
+7. 现在得到预期看板内容
+
+
+
+8. 点击工作台左上角保存按钮，把创建好的统计罗盘保存至本地
+
+
+
+至此，已经成功将 Power BI 连接到 Apache Doris，并实现了数据分析和可视化看板制作。
diff --git a/static/images/ecomsystem/powerbi/CfGWb6oaYoj4LyxpPIGcz3Binzb.png
b/static/images/ecomsystem/powerbi/CfGWb6oaYoj4LyxpPIGcz3Binzb.png
new file mode 100644
index 00000000000..e7c1e3959ea
Binary files /dev/null and
b/static/images/ecomsystem/powerbi/CfGWb6oaYoj4LyxpPIGcz3Binzb.png differ
diff --git a/static/images/ecomsystem/powerbi/FZL5b2kJcoifIaxI7Eocpak7nvf.png
b/static/images/ecomsystem/powerbi/FZL5b2kJcoifIaxI7Eocpak7nvf.png
new file mode 100644
index 00000000000..da6b7c1496f
Binary files /dev/null and
b/static/images/ecomsystem/powerbi/FZL5b2kJcoifIaxI7Eocpak7nvf.png differ
diff --git a/static/images/ecomsystem/powerbi/J7xObwqSYoTdTQx3hjgcAjQznS5.png
b/static/images/ecomsystem/powerbi/J7xObwqSYoTdTQx3hjgcAjQznS5.png
index 19a646e2d4b..c07033d48a3 100644
Binary files a/static/images/ecomsystem/powerbi/J7xObwqSYoTdTQx3hjgcAjQznS5.png
and b/static/images/ecomsystem/powerbi/J7xObwqSYoTdTQx3hjgcAjQznS5.png differ
diff --git a/static/images/ecomsystem/powerbi/JxpJbihDHoHGwixjWQScNyxvn4e.png
b/static/images/ecomsystem/powerbi/JxpJbihDHoHGwixjWQScNyxvn4e.png
new file mode 100644
index 00000000000..b21366ab8cc
Binary files /dev/null and
b/static/images/ecomsystem/powerbi/JxpJbihDHoHGwixjWQScNyxvn4e.png differ
diff --git a/static/images/ecomsystem/powerbi/LomhbQTPPoZr58xp8f3cxcTen8d.png
b/static/images/ecomsystem/powerbi/LomhbQTPPoZr58xp8f3cxcTen8d.png
new file mode 100644
index 00000000000..c01dc8b068c
Binary files /dev/null and
b/static/images/ecomsystem/powerbi/LomhbQTPPoZr58xp8f3cxcTen8d.png differ
diff --git a/static/images/ecomsystem/powerbi/MB34bks6woK3mDx0eVccivKEngc.png
b/static/images/ecomsystem/powerbi/MB34bks6woK3mDx0eVccivKEngc.png
new file mode 100644
index 00000000000..443c75de8d5
Binary files /dev/null and
b/static/images/ecomsystem/powerbi/MB34bks6woK3mDx0eVccivKEngc.png differ
diff --git a/static/images/ecomsystem/powerbi/UxL2b1OV2or1LhxZjHsc0JG7ntb.png
b/static/images/ecomsystem/powerbi/UxL2b1OV2or1LhxZjHsc0JG7ntb.png
new file mode 100644
index 00000000000..1ec0fa55a56
Binary files /dev/null and
b/static/images/ecomsystem/powerbi/UxL2b1OV2or1LhxZjHsc0JG7ntb.png differ
diff --git a/static/images/ecomsystem/powerbi/V7PsbP3oKoJpLjxK5HdcPsnLnKf.png
b/static/images/ecomsystem/powerbi/V7PsbP3oKoJpLjxK5HdcPsnLnKf.png
new file mode 100644
index 00000000000..200fbba6feb
Binary files /dev/null and
b/static/images/ecomsystem/powerbi/V7PsbP3oKoJpLjxK5HdcPsnLnKf.png differ
diff --git a/static/images/ecomsystem/powerbi/Mpeib5CoeoHZGIxrxDYcdeUwnAe.png
b/static/images/ecomsystem/powerbi/WozGbmqAOoP2mqxq2NmcJRFyntc.png
similarity index 100%
rename from static/images/ecomsystem/powerbi/Mpeib5CoeoHZGIxrxDYcdeUwnAe.png
rename to static/images/ecomsystem/powerbi/WozGbmqAOoP2mqxq2NmcJRFyntc.png
diff --git a/versioned_docs/version-3.x/ecosystem/bi/powerbi.md
b/versioned_docs/version-3.x/ecosystem/bi/powerbi.md
index 9a7f9cea5b9..a3f52c9433b 100644
--- a/versioned_docs/version-3.x/ecosystem/bi/powerbi.md
+++ b/versioned_docs/version-3.x/ecosystem/bi/powerbi.md
@@ -136,14 +136,52 @@ Finally, you should see the databases and tables in the
Navigator view. Select t
-After the import is complete, your Doris data should be accessible in Power BI
as usual.
+After the import is complete, your Doris data should be accessible in Power BI
as usual, Configure the required statistical compass.
-Configure the required statistical compass
+## Building Visualizations in Power BI
-
+We've chosen TPC-H data as our data source. For instructions on building a
Doris TPC-H data source, refer to [this document](../../benchmark/tpch).
+Now that we've configured the Doris data source in Power BI, let's visualize
the data...
-Save the created statistical compass locally
+Suppose we need to know the order revenue statistics across different regions.
We'll build a dashboard based on this requirement.
-
+1. First, create the table model relationships. Click Model view.
+
+
+
+2. Drag and drop to place these four tables on the same screen as needed, and
then drag and drop the related fields.
+
+
+
+
+
+The relationships between the four tables are as follows:
+
+- **customer** ：c_nationkey -- **nation** : n_nationkey
+- **customer** ：c_custkey -- **orders** : o_custkey
+- **nation** : n_regionkey -- **region** : r_regionkey
+
+3. The results after association are as follows:
+
+
+
+4. Return to the Report view workbench and build the dashboard.
+5. Drag the `o_totalprice` field from the `orders` table to the dashboard.
+
+
+
+6. Drag the `r_name` field from the `region` table to column X.
+
+
+
+7. You should now have the expected dashboard content.
+
+
+
+8. Click the save button in the upper left corner of the workbench to save the
created statistical compass to your local machine.
+
+
+
+At this point, you have successfully connected Power BI to Apache Doris and
implemented data analysis and dashboard creation.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
