Hello, StarRocks team! I am using the MySQL ODBC Unicode Driver 8.0.28 (as noted here: https://forum.starrocks.io/t/starrocks-powerbi-integration/370) to integrate StarRocks with Power BI Desktop. The integration works, but it is too slow. For example, a StarRocks table with 14 million rows and approximately 300 MB in size takes around 20 minutes to load into Power BI. Are there newer solutions for integrating StarRocks with Power BI, or are there any parameters that i can tune to speed up the integration? I compared this with the Microsoft SQL Server and Power BI integration (using ODBC Driver 17 for SQL Server), where loading a table of the same size from SQL Server into Power BI takes no more than one minute. Appreciate it in advance! P.s. Starrocks version 3.5.2 and Power BI Desktop version is 2.150.2102.0 64-bit

@Егор Василевич Hi how do you think about using MariaDB Connector instead? MariaDB Connector can use DirectQuery.

i think that version maybe too old? the latest odbc version is 9.6.0 , do u want to try?

I’m not sure why Microsoft doesn’t support the DirectQuery feature for MySQL, while it is supported for PostgreSQL. • Power Query MySQL database connector - Power Query | Microsoft Learn • Power Query PostgreSQL connector - Power Query | Microsoft Learn In the case of MariaDB, they created their own DirectQuery driver(Microsoft certified connector): MariaDB Direct Query Adapter For Microsoft Power BI | Server | MariaDB Documentation

not sure if power bi have the adbc driver https://docs.starrocks.io/docs/unloading/arrow_flight/

That's a good observation. According to their connector documentation, Microsoft doesn't currently support Arrow Flight connectors. List of all Power Query connectors - Power Query | Microsoft Learn However, third-party drivers like Dremio's Arrow Flight SQL ODBC might work Arrow Flight SQL ODBC | Dremio Documentation(from Dremio) But I didn't try this one.

Hi guys! Thank you so much for your responses. I’ll try your suggested solutions and get back to you!