Forum Discussion

vsam_automation's avatar
vsam_automation
Regular Visitor
1 year ago

Power BI Service Data Refresh Error (An error happened while reading data from the provider)

Hi, I'm Victor, I built a report using MySQL database. The connection works fine on PBI Desktop, but when I publish and try to refresh the data in PBI Service, it takes a long time (like 2-5min) and...
Need Help
vsam_automation's avatar
vsam_automation
Regular Visitor
1 year ago

Hi v-lgarikapat , the issue has not yet been resolved. Power BI desktop does not show any errors. Only service fails to refresh. Microsoft Support suggested U use SslMode=none but  the connection string I'm using does not support it
This is failing

= MySQL.Database({MY SERVER}, {MY_PASSWORD}, [ReturnSingleDatabase=true, CreateNavigationProperties=false,SslMode=none])

 

Expression.Error: The name 'none' wasn't recognized.  Make sure it's spelled correctly.

 

v-lgarikapat's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
1 year ago

Hi vsam_automation ,

Apologies for the inconvenience. Could you please try the workaround mentioned below and let us know if it resolves the issue?

 

Workaround: Use ODBC Instead

To bypass this limitation, switch to an ODBC connection where you can explicitly define SSL behavior.

Example M Code Using ODBC:

powerquery

let

    connectionString =

        "Driver={MySQL ODBC 8.0 Unicode Driver};Server=your_server;Database=your_db;Uid=your_user;Pwd=your_password;SslMode=DISABLED;",

    Source = Odbc.Query(connectionString, "SELECT * FROM your_table")

in

    Source

Steps:

  1. Install the MySQL ODBC 8.0 Unicode Driver.
  2. Use Odbc.Query() instead of MySQL.Database().
  3. Set SslMode=DISABLED in the connection string.

 Gateway Considerations

If you're publishing to Power BI Service:

  • Make sure the ODBC driver is installed on the machine running the On-Premises Data Gateway.
  • Configure the gateway to use the same DSN or connection string.

 

Best Regards,

Lakshmi.