1. Home
  2. Guides
  3. Concepts
  4. Tools
  5. References
  6. Integrations
    1. Incorta Copilot for Slack
    2. Microsoft Excel Add-in
    3. Fabric with Advanced SQLi
    4. Microsoft Power BI
    5. Power BI With Advanced SQLi
    6. Microsoft Teams
    7. Slack
    8. Tableau for SQLi
    9. Tableau for Advanced SQLi
    10. XLCubed
  7. Data applications
  8. Release Notes
  9. Incorta Premium

Integrations → Power BI with Advanced SQLi

Microsoft Power BI is a business intelligence tool that transforms raw data from various sources into interactive visualizations and insightful dashboards. With the introduction of the Advanced SQL interface in Incorta 2024.1.x and significant enhancements to Native Hive and Spark SQL connectivity in 2024.7.5, you can now seamlessly connect Power BI to Incorta through the Advanced SQLi. This connection supports both DirectQuery and Import data connectivity modes.

Configure Power BI to connect to Incorta

You can connect Power BI to Incorta's Advanced SQLi using two primary methods:

  1. In the Power BI Desktop client, select New Source.

  2. In the Get Data dialog, select the Spark connector, and then select Connect.

  3. In the Spark configurations dialog, enter the following details:

    • In Server, enter the Incorta URL in one of the following formats:

      • For Incorta Cloud: https://<ClusterName>-sqlx.spark-cloud.incorta.com:443/<httpPath>

        Note

        You can get the HTTP Path from the Advanced SQL Interface Connection String, available when you turn on the Enable Advanced SQL Interface option in the Cloud Admin Portal > Clusters > <CLUSTER_NAME> > Configurations.

        Example:

        • If the Advanced SQL Interface Connection String is: jdbc:hive2://MyCluster-sqlx.spark-cloud.incorta.com:443/;transportMode=http;httpPath=gc-us-central1-a-13/cliservice;ssl=true
        • The Server URL will be: https://MyCluster-sqlx.spark-cloud.incorta.com:443/gc-us-central1-a-13/cliservice

      • For On-Premises: <PublicIP>:<KyuubiPort>
        Example: 203.0.113.45:10009

        Note

        You can use one of the following Kyuubi ports: kyuubi.frontend.thrift.http.bind.port or kyuubi.frontend.thrift.binary.bind.port

    • In Protocol, select HTTP to connect to Incorta Cloud, or Standard to connect to an Incorta On-Premises cluster.

    • For Data Connectivity mode, select Import or DirectQuery.

      Important

      Performance when connecting in Import mode has been significantly enhanced starting 2024.7.5.

    • Select OK.

  4. In User name, enter the Incorta username in the following format: <IncortaUser>%<tenantName>.
    Example: admin%default.

  5. In Password, enter a valid personal access token (PAT).

  6. Select Connect. Schemas, tables, and views available to Advanced SQLi are listed.

Connect to Incorta via Sibma Spark ODBC

Set up an ODBC DSN

  1. On the Windows host, in the Control Panel, select Administrative Tools, and then select Data Sources (ODBC).
  2. In the ODBC Data Source Administrator dialog, click the System DSN tab, and then click Add.
  3. In the Create New Data Source dialog, select Simba Spark ODBC Driver.
  4. In the Simba Spark ODBC Driver DSN Setup dialog, enter the following details:
    • In Data Source Name, enter a name for the ODBC connection.
    • In Host(s), enter the Incorta URL in one of the following formats:
      • For Incorta Cloud: <ClusterName>-sqlx.spark-cloud.incorta.com
        Example: MyCluster-sqlx.spark-cloud.incorta.com
      • For On-Premises clusters: The Public IP address of the Incorta host.
        Example: 203.0.113.45
    • In Port, enter the Advanced SQL port.
      • For Incorta Cloud: The port specified in the Advanced SQLi connection string, i.e, 443
      • For On-Premises clusters: The Advanced SQL service Port or Binary Port, for example 10010
    • Under Authentication, in Mechanism, select the authentication method User Name and Password.
    • In User name, enter the Incorta username in the following format: <IncortaUser>%<tenantName>.
      Example: admin%default.
    • In Password, enter a valid personal access token (PAT).
    • In Thrift Transport, select HTTP.
    • Select HTTP Options, and then in the HTTP Properties dialog, enter the HTTP path.
      • For Incorta Cloud: Enter the HTTP Path specified in the Advanced SQL Interface Connection.
        Example: gc-us-central1-a-13/cliservice
      • For On-Premises clusters: Enter cliservice.
    • Select SSL Options, and then in the SSL Options dialog, select the following check boxes:
      • Enable SSL
      • Use System Trust Store
  5. Select Test to verify the connection.

Connect from Power BI Desktop using the configured ODBC DSN

  1. In the Power BI Desktop client, select New Source.
  2. In the Get Data dialog, select the ODBC, and then select Connect.
  3. In the From ODBC dialog, from Data source name (DSN), select the name of the Simba Spark ODBC connection you created, then select OK.
  4. In the ODBC driver dialog, enter the username and password (PAT) you provided during the DSN setup, then select Connect. Schemas, tables, and views available to Advanced SQLi are listed.