Forum Discussion
Intermittent error while refreshing Mysql data
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.
Hi netvalue If multiple datasets or reports are refreshing simultaneously, it may exceed the capacity of your workspace. This may cause so try staggering the refresh schedule to avoid conflicts. Ensure the refresh operations are not hitting capacity limits on the PPU license.
Thank you, as you can see from the screenshot the scheduling happens every hour and usually takes 5 minutes (except when it goes wrong which goes up to 15 minutes) so I doubt it's a concurrency problem.
The dataset is only one and is updated fewer times than the 48 available from the PPU license.
Anyway is there a way to check if this capability is somehow exceeded or a more detailed way to debug the error?
