Forum Discussion
Power BI Service Data Refresh Error (An error happened while reading data from the provider)
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.
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
