You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by lu...@apache.org on 2024/04/20 23:04:55 UTC
(doris-website) branch master updated: add powerbi docs (#576)
This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 eabb25b564 add powerbi docs (#576)
eabb25b564 is described below
commit eabb25b564d5d3a66f9c4b8eb95cc2bb8c5492cd
Author: wyx123654 <45...@users.noreply.github.com>
AuthorDate: Sun Apr 21 07:04:50 2024 +0800
add powerbi docs (#576)
---
docs/ecosystem/bi/powerbi.md | 102 ++++++++++++++++++++
.../current/ecosystem/bi/powerbi.md | 103 +++++++++++++++++++++
.../version-2.0/ecosystem/bi/powerbi.md | 103 +++++++++++++++++++++
.../version-2.1/ecosystem/bi/powerbi.md | 103 +++++++++++++++++++++
sidebars.json | 3 +-
static/images/powerbi/bi-powerbi-en-1.png | Bin 0 -> 93423 bytes
static/images/powerbi/bi-powerbi-en-10.png | Bin 0 -> 128607 bytes
static/images/powerbi/bi-powerbi-en-11.png | Bin 0 -> 30263 bytes
static/images/powerbi/bi-powerbi-en-12.png | Bin 0 -> 136229 bytes
static/images/powerbi/bi-powerbi-en-13.png | Bin 0 -> 54941 bytes
static/images/powerbi/bi-powerbi-en-2.png | Bin 0 -> 124016 bytes
static/images/powerbi/bi-powerbi-en-3.png | Bin 0 -> 272056 bytes
static/images/powerbi/bi-powerbi-en-4.png | Bin 0 -> 15506 bytes
static/images/powerbi/bi-powerbi-en-5.png | Bin 0 -> 17005 bytes
static/images/powerbi/bi-powerbi-en-6.png | Bin 0 -> 226026 bytes
static/images/powerbi/bi-powerbi-en-7.png | Bin 0 -> 243486 bytes
static/images/powerbi/bi-powerbi-en-8.png | Bin 0 -> 23773 bytes
static/images/powerbi/bi-powerbi-en-9.png | Bin 0 -> 151311 bytes
versioned_docs/version-2.0/ecosystem/bi/powerbi.md | 102 ++++++++++++++++++++
versioned_docs/version-2.1/ecosystem/bi/powerbi.md | 102 ++++++++++++++++++++
versioned_sidebars/version-2.0-sidebars.json | 3 +-
versioned_sidebars/version-2.1-sidebars.json | 3 +-
22 files changed, 621 insertions(+), 3 deletions(-)
diff --git a/docs/ecosystem/bi/powerbi.md b/docs/ecosystem/bi/powerbi.md
new file mode 100644
index 0000000000..28583a8cd4
--- /dev/null
+++ b/docs/ecosystem/bi/powerbi.md
@@ -0,0 +1,102 @@
+---
+{
+ "title": "Power-BI",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Power BI Introduction
+
+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 and Apache Doris through MySQL driver. At present, internal data modeling, data query and visualization processing of Apache Doris have been officially supported in Power BI.
+
+## Precondition
+
+If you do not have PowerBI desktop installed, you can download it from https://www.microsoft.com/
+
+## Connector configuration of PowerBI and Doris
+:::info Note
+Currently verified using MySQL jdbc connector version 8.0.26
+:::
+
+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
+
+
+## Load data locally and create models
+
+1. Start the Power BI Desktop
+
+ 
+
+2. Open the Power BI Desktop screen and click Create Report. If a local report exists, you can open it.
+
+ 
+
+3. Click get data. In the dialog box that is displayed, select MySQL database.
+
+ 
+
+4. Configure the database connection information and enter ip:port in the server text box. The default port number for 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 user name and password.
+
+ 
+
+6. Load the selected table to the Power BI Desktop
+
+ 
+
+7. Configure statistical compass
+
+ 
+
+8. Save statistical compass to location
+
+ 
+
+## Set data refresh automatic
+
+1. Download the On-premises data gateway. Download address: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
+2. Install the On-premises data gateway
+
+ 
+
+3. Log into Power BI Online and import the local model in your workspace
+
+ 
+
+4. Click the model to set the automatic refresh time
+
+ 
+
+5. The data refresh configuration requires a gataway connection. After the gateway is enabled locally, you can see the started gateway in the gateway connection locally. Select the local gateway.
+
+ 
+
+6. Configure the refresh schedule to complete the automatic data refresh on Power BI
+
+ 
+
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
new file mode 100644
index 0000000000..ada9596c9c
--- /dev/null
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/powerbi.md
@@ -0,0 +1,103 @@
+---
+{
+ "title": "Power-BI",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Power BI 介绍
+
+Power BI是软件服务、应用连接器的集合，其可以连接到多种数据源，包括Excel、SQL Server、Azure、Google Analytics等，以便用户可以轻松得整合和清洗数据。通过Power BI的数据建模，用户可以创建关系模型、数据分析表达式和数据关系，以支持高级的数据分析和可视化。Power BI提供了丰富的可视化选项，包括图标、地图、仪表盘和自定义可视化工具，以帮助用户更直观地理解数据。
+
+Apache Doris 高度兼容 MySQL 协议，可以通过 MySQL 驱动器连接Power BI 与 Apache Doris，当前Power BI中已经正式支持了Apache Doris的内部数据建模以及数据查询与可视化处理。
+
+## 前置条件
+
+未安装Power BI Desktop可以访问https://www.microsoft.com/ 下载安装Power BI。
+
+## PowerBI与doris的connector配置
+
+:::info Note
+选择8.0.26版本的MySQL jdbc connector
+:::
+
+MySQL connector 下载
+
+下载链接：https://downloads.mysql.com/archives/c-net/
+
+## 本地加载数据与创建模型
+
+1. 启动 Power BI Desktop
+
+ 
+
+2. 在Power BI Desktop打开界面点击新建报表。若已有本地报表可以选择打开已有报表
+
+ 
+
+3. 点击获取数据，在弹出窗口中选择MySQL数据库
+
+ 
+
+4. 配置数据库连接信息，在服务器输入框中输入ip:port。doris默认的端口号为9030
+
+ 
+
+5. 上一步点击确定后在新的连接窗口处选择"数据库"连接，并在用户名与密码处填写doris的连接信息。
+
+ 
+
+6. 加载选中的表，使其表中数据至Power BI Desktop
+
+ 
+
+7. 配置需要的统计罗盘
+
+ 
+
+8. 把创建好的统计罗盘保存至本地
+
+ 
+
+## 设置数据自动刷新
+
+1. 下载On-premises data gateway。下载地址：https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
+2. 安装On-premises data gateway
+
+ 
+
+3. 登陆Power BI Online，在个人的工作区中把刚保存的本地模型进行导入
+
+ 
+
+4. 点击模型配置自动刷新时间
+
+ 
+
+5. 数据刷新的配置需要有gataway连接，本地开启网关后可以在网关连接中看到本地启动的网关，选取本地的网关即可。更多关于gateway：https://learn.microsoft.com/zh-cn/power-bi/connect-data/service-gateway-onprem
+
+ 
+
+6. 配置相关刷新计划即可完成Power BI自动数据刷新
+
+ 
+
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/powerbi.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/powerbi.md
new file mode 100644
index 0000000000..6f13e068dc
--- /dev/null
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/powerbi.md
@@ -0,0 +1,103 @@
+---
+{
+ "title": "Power-BI",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Power BI 介绍
+
+Power BI是软件服务、应用连接器的集合，其可以连接到多种数据源，包括Excel、SQL Server、Azure、Google Analytics等，以便用户可以轻松得整合和清洗数据。通过Power BI的数据建模，用户可以创建关系模型、数据分析表达式和数据关系，以支持高级的数据分析和可视化。Power BI提供了丰富的可视化选项，包括图标、地图、仪表盘和自定义可视化工具，以帮助用户更直观地理解数据。
+
+Apache Doris 高度兼容 MySQL 协议，可以通过 MySQL 驱动器连接Power BI 与 Apache Doris，当前Power BI中已经正式支持了Apache Doris的内部数据建模以及数据查询与可视化处理。
+
+## 前置条件
+
+未安装Power BI Desktop可以访问https://www.microsoft.com/ 下载安装Power BI。
+
+## PowerBI与doris的connector配置
+
+:::info Note
+选择8.0.26版本的MySQL jdbc connector
+:::
+
+MySQL connector 下载
+
+下载链接：https://downloads.mysql.com/archives/c-net/
+
+## 本地加载数据与创建模型
+
+1. 启动 Power BI Desktop
+
+ 
+
+2. 在Power BI Desktop打开界面点击新建报表。若已有本地报表可以选择打开已有报表
+
+ 
+
+3. 点击获取数据，在弹出窗口中选择MySQL数据库
+
+ 
+
+4. 配置数据库连接信息，在服务器输入框中输入ip:port。doris默认的端口号为9030
+
+ 
+
+5. 上一步点击确定后在新的连接窗口处选择"数据库"连接，并在用户名与密码处填写doris的连接信息。
+
+ 
+
+6. 加载选中的表，使其表中数据至Power BI Desktop
+
+ 
+
+7. 配置需要的统计罗盘
+
+ 
+
+8. 把创建好的统计罗盘保存至本地
+
+ 
+
+## 设置数据自动刷新
+
+1. 下载On-premises data gateway。 下载地址：https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
+2. 安装On-premises data gateway
+
+ 
+
+3. 登陆Power BI Online，在个人的工作区中把刚保存的本地模型进行导入
+
+ 
+
+4. 点击模型配置自动刷新时间
+
+ 
+
+5. 数据刷新的配置需要有gataway连接，本地开启网关后可以在网关连接中看到本地启动的网关，选取本地的网关即可。更多关于gateway：https://learn.microsoft.com/zh-cn/power-bi/connect-data/service-gateway-onprem
+
+ 
+
+6. 配置相关刷新计划即可完成Power BI自动数据刷新
+
+ 
+
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/powerbi.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/powerbi.md
new file mode 100644
index 0000000000..764d1c4a89
--- /dev/null
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/powerbi.md
@@ -0,0 +1,103 @@
+---
+{
+ "title": "Power-BI",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Power BI 介绍
+
+Power BI是软件服务、应用连接器的集合，其可以连接到多种数据源，包括Excel、SQL Server、Azure、Google Analytics等，以便用户可以轻松得整合和清洗数据。通过Power BI的数据建模，用户可以创建关系模型、数据分析表达式和数据关系，以支持高级的数据分析和可视化。Power BI提供了丰富的可视化选项，包括图标、地图、仪表盘和自定义可视化工具，以帮助用户更直观地理解数据。
+
+Apache Doris 高度兼容 MySQL 协议，可以通过 MySQL 驱动器连接Power BI 与 Apache Doris，当前Power BI中已经正式支持了Apache Doris的内部数据建模以及数据查询与可视化处理。
+
+## 前置条件
+
+未安装Power BI Desktop可以访问https://www.microsoft.com/ 下载安装Power BI。
+
+## PowerBI与doris的connector配置
+
+:::info Note
+选择8.0.26版本的MySQL jdbc connector
+:::
+
+MySQL connector 下载
+
+下载链接：https://downloads.mysql.com/archives/c-net/
+
+## 本地加载数据与创建模型
+
+1. 启动 Power BI Desktop
+
+ 
+
+2. 在Power BI Desktop打开界面点击新建报表。若已有本地报表可以选择打开已有报表
+
+ 
+
+3. 点击获取数据，在弹出窗口中选择MySQL数据库
+
+ 
+
+4. 配置数据库连接信息，在服务器输入框中输入ip:port。doris默认的端口号为9030
+
+ 
+
+5. 上一步点击确定后在新的连接窗口处选择"数据库"连接，并在用户名与密码处填写doris的连接信息。
+
+ 
+
+6. 加载选中的表，使其表中数据至Power BI Desktop
+
+ 
+
+7. 配置需要的统计罗盘
+
+ 
+
+8. 把创建好的统计罗盘保存至本地
+
+ 
+
+## 设置数据自动刷新
+
+1. 下载On-premises data gateway。下载地址：https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
+2. 安装On-premises data gateway
+
+ 
+
+3. 登陆Power BI Online，在个人的工作区中把刚保存的本地模型进行导入
+
+ 
+
+4. 点击模型配置自动刷新时间
+
+ 
+
+5. 数据刷新的配置需要有gataway连接，本地开启网关后可以在网关连接中看到本地启动的网关，选取本地的网关即可。更多关于gateway：https://learn.microsoft.com/zh-cn/power-bi/connect-data/service-gateway-onprem
+
+ 
+
+6. 配置相关刷新计划即可完成Power BI自动数据刷新
+
+ 
+
diff --git a/sidebars.json b/sidebars.json
index 0609bcce92..5c13b69a92 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -301,7 +301,8 @@
"items": [
"ecosystem/bi/apache-superset",
"ecosystem/bi/dbeaver",
- "ecosystem/bi/datagrip"
+ "ecosystem/bi/datagrip",
+ "ecosystem/bi/powerbi"
]
},
{
diff --git a/static/images/powerbi/bi-powerbi-en-1.png b/static/images/powerbi/bi-powerbi-en-1.png
new file mode 100644
index 0000000000..7cb9e89f09
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-1.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-10.png b/static/images/powerbi/bi-powerbi-en-10.png
new file mode 100644
index 0000000000..bb7c0cb654
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-10.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-11.png b/static/images/powerbi/bi-powerbi-en-11.png
new file mode 100644
index 0000000000..9eae8e4dd4
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-11.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-12.png b/static/images/powerbi/bi-powerbi-en-12.png
new file mode 100644
index 0000000000..2d58b89ebe
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-12.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-13.png b/static/images/powerbi/bi-powerbi-en-13.png
new file mode 100644
index 0000000000..52263d708d
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-13.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-2.png b/static/images/powerbi/bi-powerbi-en-2.png
new file mode 100644
index 0000000000..9ab327f9d2
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-2.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-3.png b/static/images/powerbi/bi-powerbi-en-3.png
new file mode 100644
index 0000000000..46f6a9d1ea
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-3.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-4.png b/static/images/powerbi/bi-powerbi-en-4.png
new file mode 100644
index 0000000000..41f7b92489
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-4.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-5.png b/static/images/powerbi/bi-powerbi-en-5.png
new file mode 100644
index 0000000000..e88d05f703
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-5.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-6.png b/static/images/powerbi/bi-powerbi-en-6.png
new file mode 100644
index 0000000000..d0070cb3a0
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-6.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-7.png b/static/images/powerbi/bi-powerbi-en-7.png
new file mode 100644
index 0000000000..bf372bbec9
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-7.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-8.png b/static/images/powerbi/bi-powerbi-en-8.png
new file mode 100644
index 0000000000..85a696bd33
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-8.png differ
diff --git a/static/images/powerbi/bi-powerbi-en-9.png b/static/images/powerbi/bi-powerbi-en-9.png
new file mode 100644
index 0000000000..5cb0d30f8d
Binary files /dev/null and b/static/images/powerbi/bi-powerbi-en-9.png differ
diff --git a/versioned_docs/version-2.0/ecosystem/bi/powerbi.md b/versioned_docs/version-2.0/ecosystem/bi/powerbi.md
new file mode 100644
index 0000000000..c795b406d2
--- /dev/null
+++ b/versioned_docs/version-2.0/ecosystem/bi/powerbi.md
@@ -0,0 +1,102 @@
+---
+{
+ "title": "Power-BI",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Power BI Introduction
+
+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 and Apache Doris through MySQL driver. At present, internal data modeling, data query and visualization processing of Apache Doris have been officially supported in Power BI.
+
+## Precondition
+
+If you do not have PowerBI desktop installed, you can download it from https://www.microsoft.com/
+
+## Connector configuration of PowerBI and Doris
+:::info Note
+Currently verified using MySQL jdbc connector version 8.0.26
+:::
+
+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
+
+
+## Load data locally and create models
+
+1. Start the Power BI Desktop
+
+ 
+
+2. Open the Power BI Desktop screen and click Create Report. If a local report exists, you can open it.
+
+ 
+
+3. Click get data. In the dialog box that is displayed, select MySQL database.
+
+ 
+
+4. Configure the database connection information and enter ip:port in the server text box. The default port number for 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 user name and password.
+
+ 
+
+6. Load the selected table to the Power BI Desktop
+
+ 
+
+7. Configure statistical compass
+
+ 
+
+8. Save statistical compass to location
+
+ 
+
+## Set data refresh automatic
+
+1. Download the On-premises data gateway. Download address: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
+2. Install the On-premises data gateway
+
+ 
+
+3. Log into Power BI Online and import the local model in your workspace
+
+ 
+
+4. Click the model to set the automatic refresh time
+
+ 
+
+5. The data refresh configuration requires a gataway connection. After the gateway is enabled locally, you can see the started gateway in the gateway connection locally. Select the local gateway.
+
+ 
+
+6. Configure the refresh schedule to complete the automatic data refresh on Power BI
+
+ 
+
diff --git a/versioned_docs/version-2.1/ecosystem/bi/powerbi.md b/versioned_docs/version-2.1/ecosystem/bi/powerbi.md
new file mode 100644
index 0000000000..c795b406d2
--- /dev/null
+++ b/versioned_docs/version-2.1/ecosystem/bi/powerbi.md
@@ -0,0 +1,102 @@
+---
+{
+ "title": "Power-BI",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Power BI Introduction
+
+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 and Apache Doris through MySQL driver. At present, internal data modeling, data query and visualization processing of Apache Doris have been officially supported in Power BI.
+
+## Precondition
+
+If you do not have PowerBI desktop installed, you can download it from https://www.microsoft.com/
+
+## Connector configuration of PowerBI and Doris
+:::info Note
+Currently verified using MySQL jdbc connector version 8.0.26
+:::
+
+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
+
+
+## Load data locally and create models
+
+1. Start the Power BI Desktop
+
+ 
+
+2. Open the Power BI Desktop screen and click Create Report. If a local report exists, you can open it.
+
+ 
+
+3. Click get data. In the dialog box that is displayed, select MySQL database.
+
+ 
+
+4. Configure the database connection information and enter ip:port in the server text box. The default port number for 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 user name and password.
+
+ 
+
+6. Load the selected table to the Power BI Desktop
+
+ 
+
+7. Configure statistical compass
+
+ 
+
+8. Save statistical compass to location
+
+ 
+
+## Set data refresh automatic
+
+1. Download the On-premises data gateway. Download address: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
+2. Install the On-premises data gateway
+
+ 
+
+3. Log into Power BI Online and import the local model in your workspace
+
+ 
+
+4. Click the model to set the automatic refresh time
+
+ 
+
+5. The data refresh configuration requires a gataway connection. After the gateway is enabled locally, you can see the started gateway in the gateway connection locally. Select the local gateway.
+
+ 
+
+6. Configure the refresh schedule to complete the automatic data refresh on Power BI
+
+ 
+
diff --git a/versioned_sidebars/version-2.0-sidebars.json b/versioned_sidebars/version-2.0-sidebars.json
index d968210c14..3429b329cb 100644
--- a/versioned_sidebars/version-2.0-sidebars.json
+++ b/versioned_sidebars/version-2.0-sidebars.json
@@ -487,7 +487,8 @@
"items": [
"ecosystem/bi/apache-superset",
"ecosystem/bi/dbeaver",
- "ecosystem/bi/datagrip"
+ "ecosystem/bi/datagrip",
+ "ecosystem/bi/powerbi"
]
}
]
diff --git a/versioned_sidebars/version-2.1-sidebars.json b/versioned_sidebars/version-2.1-sidebars.json
index e785c56965..3a2a3e5cb9 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -299,7 +299,8 @@
"items": [
"ecosystem/bi/apache-superset",
"ecosystem/bi/dbeaver",
- "ecosystem/bi/datagrip"
+ "ecosystem/bi/datagrip",
+ "ecosystem/bi/powerbi"
]
},
{
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org