Hi @yongjelly
check below steps
The error message you're encountering suggests that the Power Query engine in Power BI is unable to recognize the ODBC driver you specified in your connection string.
1. **Verify ODBC Driver Installation**:
- First, make sure that the MariaDB ODBC driver is correctly installed on the machine where you are running Power BI Desktop. If it's not installed, download and install the MariaDB ODBC driver from the MariaDB website.
2. **Use the Correct Driver Name**:
- Double-check that you are using the correct driver name in your ODBC connection string. The driver name may differ based on the version and installation path. It's a good idea to review the driver's documentation or consult with your database administrator to ensure you are using the correct name.
3. **Data Source Settings**:
- In Power BI Desktop, go to the "Home" tab and click on "Get Data."
- Select "ODBC" from the list of data sources.
- In the "ODBC Data Source" dialog, provide the connection string again, making sure it matches the correct driver name and includes the server, port, and database name.
- Click "OK" to proceed.
4. **ODBC DSN (Optional)**:
- Instead of specifying the connection string directly, consider setting up an ODBC Data Source Name (DSN) for your MariaDB connection. This can simplify the connection process and make it less error-prone.
- To create an ODBC DSN, go to your Windows Control Panel, search for "ODBC," and select "Set up ODBC Data Sources." Then, configure a new DSN for your MariaDB connection, specifying the driver and connection details.
5. **Driver Compatibility**:
- Ensure that the version of the MariaDB ODBC driver you have installed is compatible with your MariaDB server version. Incompatibility between the driver and the server can lead to connection issues.
6. **Restart Power BI**:
- After making any changes or installations, it's a good practice to restart Power BI Desktop to ensure that the newly installed driver is recognized.
7. **Firewall and Network Settings**:
- Make sure that there are no firewall or network restrictions preventing Power BI from accessing the MariaDB server. Check that the server IP and port are reachable from your machine.
If you've followed these steps and are still encountering issues, consider reaching out to your database administrator or MariaDB support for further assistance, as the problem might be related to server configuration or specific driver compatibility issues.
