Forum Discussion

netvalue's avatar
netvalue
New Member
1 year ago
Solved

Intermittent error while refreshing Mysql data

Hello, i have configured a refresh schedule of my data model linked to a Mysql istance to be execute from 8:00 to 00:00 every hour. Sometimes i get this error: DataSource.Error: An error happened ...
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi netvalue,

     

    After thoroughly reviewing the details you provided, I have identified few alternative workarounds that may help resolve the issue. Please follow these steps:

     

    Go to Power BI Service → Dataset Settings → Refresh History. Look for any failed refresh entries and click on them to see if there are additional details provided.

    In Power BI Service, you can enable diagnostic logging to capture more detailed information about the refresh process. Navigate to Power BI Service, go to Dataset Settings → Diagnostics, and enable Enhanced Refresh Errors (if available). Try another refresh and check if it provides more details.

    Power BI Desktop diagnostics collection - Power BI | Microsoft Learn

     

    Instead of MySQL, try connecting via ODBC or MySQL .NET Connector. In the refresh history, find the failed refresh entry and download the error log. This log may contain more detailed information about the error.

     

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you.