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
v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi vsam_automation ,

Thanks for reaching out to the Microsoft fabric community forum.

ibarrau , GilbertQ 

Thanks for your prompt response

vsam_automation  , could you please try the troubleshooting steps provided by  ibarrau  and let us know how it goes, so we can assist you further.

 

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

 

Best Regards,

Lakshmi

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    1 year 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.

    • v-lgarikapat's avatar
      v-lgarikapat
      Community Support
      1 year 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.

      • 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.