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 then says this, 

Data source errorDataSource.Error: An error happened while reading data from the provider: 'One or more errors occurred.'. Microsoft.Data.Mashup.ErrorCode = 10434. The exception was raised by the IDbCommand interface. Table: Sales.

Note: The Table referenced in this error message is Sales, but it changes on every failed refresh. Sometimes Customers, Orders, etc. So I don't think it's related to any specific table but the entire db.
Any help will be greatly appreciated. Thanks. 

Need Help

10 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    1 year ago

    Hi vsam_automation 

     

    Can you please let us know how you are connecting your semantic model to your database? Are you using gateway or are you connecting directly? This is for us assist you with your error.

    • vsam_automation's avatar
      vsam_automation
      Regular Visitor
      1 year ago

      I'm using a cloud connection

      Connection says it's onlineCloud connection

      • ibarrau's avatar
        ibarrau
        Super User
        1 year ago

        Hi. Just to make sure there is no error in the transformations, let's do a quick check. Open power bi desktop. Go to queryeditor/transformdata. Open the tables one by one selecting all the columns and filtering by "Keep Errors". Make sure there is no row for each one. If there are no error rows at any table, then it's something with mysql and power bi service. Otherwise, you can have an error in the ETL. Sometimes power bi desktop shows warnings after apply and refresh that will be errors in Service.

        I hope that helps,

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