Forum Discussion
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...
I'm using a cloud connection
Connection says it's onlineCloud connection
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,
Hi ibarrau , thanks for your response.
Everything checked out on desktop. No errors or warnings