DLC Connect Power BI
Last updated: 2025-10-17 09:22:06
Note：
Prerequisites (Before using the connector)
A Tencent Cloud account.
Permissions to use DLC.
A created role in Cloud Access Management.
A DLC standard Spark engine and allow public access.
Install the Microsoft Spark ODBC Driver.
Install the On-premises data gateway for connections from Power BI Service.
Creating Role in Tencent Cloud Access Management
1. Use your Tencent Cloud admin account to create a Role-Based SSO. Input the Identity provider name. You can get Identity provider URL , Client ID and Signature Public Key from Microsoft Entra.You can follow this document to create an OIDC identity provider. Creating an OIDC Identity Provider.
2. You can follow this document to create a role. The value of oidc:aud (issuer address) and oidc:sub (client id) can be found in Power BI OpenID Connect Metadata document Creating Role
Power BI Desktop Setup
Install DLC ODBC Connector
1. Put DlcODBC.mez in your local [Documents]\\Power BI Desktop\\Custom Connectors folder. Create the folder if it does not exist.
2. To adjust the data extension security settings, in Power BI Desktop, select File > Options and settings > Options > Security.
3. Under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning.
4. Select OK, and then restart Power BI Desktop.
ODBC Setup
1. Open ODBC Driver. Select System DSN > Sample Microsoft Spark DSN > Setup. Then select SparkThriftServer(Spark 1.1 and later) as Spark Server Type. Input Host, Port and Database. Under Authentication select User Name and Password as Mechanism. Input user name (DataEngine ID & Resource Group). Select SASL as Thrift Transport.
2. To disable SSL, select SSL options > deselect Enable SSL > OK.
3. To adjust Advanced Options, click Advanced Options.
Select Use Native Query to enable native query, and select Get Tables With Query to enable table metadata fetching. 1000 is recommended for Rows fetched per block.
4. To reduce the metadata loaded, it is recommended to add a server side property kyuubi.dlc.schemaFilter. Select Server side Properties > add > input kyuubi.dlc.schemaFilter as the key and the database as the value > OK.
5. Then deselect Convert key Name to Lower Case and Apply properties with queries > OK.
6. Then click OK to save the configuration.
Get Data
1. Open Power BI Desktop. Click Get Data. Select Other > DlcODBC (Custom) > connect.
2. Input DSN name (Sample Microsoft Spark DSN) , engine name, resource group, Tencent Cloud Role ID, Tencent Cloud Role Provider ID, database SPARK > select Data Connectivity mode > OK.
3. Select one table or view > load.
Publish the report
1. Select the data and then publish the report.
Power BI Gateway Setup
Install DLC ODBC Connector
1. Put DlcODBC.mez in C:\\\\Windows\\ServiceProfiles\\PBIEgwService\\Documents\\Power BI Desktop\\Custom Connectors folder. If the folder doesn't exist, create it.
2. Open On-premises data gateway, set the custom data connectors folder, and then restart gateway.
Power BI Service Setup
Adjust gateway settings
1. Select Settings > Manage connections and gateways
2. Select On-premises data gateways, hover over the target gateway and click ···, then click Settings.
3. Allow user's cloud data sources and user's custom data connectors to refresh through this gateway cluster. It is recommended to distribute requests across all active gateways in this cluster for load balancing and higher throughput.
Create on-premises connection
1. Select Settings > Manage connections and gateways
2. Select + New to create a new connection. Select the target gateway and DlcODBC as the Connection type, input DSN name, engine name, resource group and Tencent Cloud Role ID. Choose Basic as Authentication method and choose Skip test connection, then click Create.
Refresh the report
1. Go to the semantic model page, select File > Settings > Gateway and cloud connections, turn on Gateway connections and select the on-premises connection which maps to the data source.
2. Refresh report.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback