# Source: https://docs.velodb.io/cloud/4.x/best-practice/bi-faq

Version: 4.x

On this page

# BI FAQ

## Power BI​

### Q1. An error occurs when you use JDBC to pull data into Desktop Power BI.
"Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding".​

Usually, this is Power BI pulling the time timeout of the data source. When
filling in the data source server and database, click the advanced option,
which has a timeout time, set the time higher.

### Q2. When the 2.1.x version uses JDBC to connect to Power BI, an error
occurs "An error happened while reading data from the provider: the given key
was not present in the dictionary".​

Run "show collation" in the database first. Generally, only utf8mb4_900_bin is
displayed, and the charset is utf8mb4. The main reason for this error is that
ID 33 needs to be found when connecting to Power BI. That is, rows with 33ids
in the table need to be upgraded to version 2.1.5 or later.

### Q3. Connection Doris Times error "Reading data from the provider times
error index and count must refer to the location within the string".​

The cause of the problem is that global parameters are loaded during the
connection process, and the SQL column names and values are the same

    
    
    SELECT  
    @@max_allowed_packet  as max_allowed_packet, @@character_set_client ,@@character_set_connection ,  
    @@license,@@sql_mode ,@@lower_case_table_names , @@autocommit ;  
    

The new optimizer can be turned off in the current version or upgraded to
version 2.0.7 or 2.1.6 or later.

### Q4. JDBC connection version 2.1.x error message "Character set 'utf8mb3'
is not supported by.net.Framework".​

This problem is easily encountered in version 2.1.x. If this problem occurs,
you need to upgrade the JDBC Driver to 8.0.32.

## Tableau​

### Q1. Version 2.0.x reports that Tableau cannot connect to the data source
with error code 37CE01A3.​

Turn off the new optimizer in the current version or upgrade to 2.0.7 or later

### Q2. SSL connection error:protocol version mismatch Failed to connect to
the MySQL server​

The cause of this error is that SSL authentication is enabled on Doris, but
SSL connections are not used during the connection. You need to disable the
enable_ssl variable in fe.conf.

### Q3. Connection error Unsupported command(COM_STMT_PREPARED)​

The MySQL driver version is improperly installed. Install the MySQL 5.1.x
connection driver instead.

On This Page

  * Power BI
    * Q1. An error occurs when you use JDBC to pull data into Desktop Power BI. "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding".
    * Q2. When the 2.1.x version uses JDBC to connect to Power BI, an error occurs "An error happened while reading data from the provider: the given key was not present in the dictionary".
    * Q3. Connection Doris Times error "Reading data from the provider times error index and count must refer to the location within the string".
    * Q4. JDBC connection version 2.1.x error message "Character set 'utf8mb3' is not supported by.net.Framework".
  * Tableau
    * Q1. Version 2.0.x reports that Tableau cannot connect to the data source with error code 37CE01A3.
    * Q2. SSL connection error version mismatch Failed to connect to the MySQL server
    * Q3. Connection error Unsupported command(COM_STMT_PREPARED)