Forum Discussion

Baqa's avatar
Baqa
Frequent Visitor
1 month ago
Solved

Issue with MySQL ODBC 8.x/9.x Drivers During Power BI Semantic Model Refresh

Hi Microsoft Support, We are using an on-premises data gateway with an ODBC connection to a MySQL database for our Power BI semantic model refreshes. Currently, we are using the MySQL ODBC 5.3 ANSI...
Need Help
  • Tahreem24's avatar
    Tahreem24
    1 month ago

    Baqa ,

    1. Short term: stay on MySQL ODBC 5.3 ANSI — it's working, and there's no functional obligation to upgrade unless you have a security/EOL driver.
    2.  If you must upgrade (e.g., 5.3 is EOL/blocked), move to an 8.x/9.x driver but:
      Create a 64-bit System DSN on the gateway,
      Set SSL Mode appropriately, force CHARSET=utf8mb4,
      Ensure the DB user uses mysql_native_password (or fully configure SHA2 + SSL),
      Restart the gateway service, then re-test the semantic model refresh.
    3. Alternative: consider the MySQL connector (Connector/NET) in Power BI instead of generic ODBC — it's the more "native" path and sidesteps several ODBC driver-default issues.
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
1 month ago

Baqa ,

  1. Short term: stay on MySQL ODBC 5.3 ANSI — it's working, and there's no functional obligation to upgrade unless you have a security/EOL driver.
  2.  If you must upgrade (e.g., 5.3 is EOL/blocked), move to an 8.x/9.x driver but:
    Create a 64-bit System DSN on the gateway,
    Set SSL Mode appropriately, force CHARSET=utf8mb4,
    Ensure the DB user uses mysql_native_password (or fully configure SHA2 + SSL),
    Restart the gateway service, then re-test the semantic model refresh.
  3. Alternative: consider the MySQL connector (Connector/NET) in Power BI instead of generic ODBC — it's the more "native" path and sidesteps several ODBC driver-default issues.