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
11 months 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
Community Support
11 months 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.

 

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    11 months ago

    Hi vsam_automation 

     

    We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

    Best Regards,
    Lakshmi.