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,
Thank you for reaching out to the Microsoft fabric community forum. Thanks Akash_Varuna, for your inputs on this issue. After thoroughly reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:
Intermittent errors during data refresh from MySQL in Fabric can be caused by network instability, database timeouts, resource limits, or connector issues. Since the refresh works in Power BI Desktop but fails in the Power BI Service, it's likely due to gateway performance or database connection limits.
Go to Power BI Service → Dataset Settings → Refresh History to find the error message. Test the connection using MySQL Workbench or any MySQL client with the same query to check if the database responds correctly. If using a Direct Query, try Import Mode (or vice versa). Change from MySQL Connector to ODBC driver to test stability.
As the issue is intermittent, please review the MySQL logs for any potential problems:
- Error logs (located at /var/log/mysql/error.log or by executing SHOW ENGINE INNODB STATUS;)
- Slow queries (execute SHOW GLOBAL STATUS LIKE 'Slow_queries';)
- Max connection limits (execute SHOW VARIABLES LIKE 'max_connections';)
If you are using an On-premises Data Gateway, please check the following. Ensure the Gateway is up to date. Review logs located at C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics\Gateway*.log. Restart the Gateway service.
Ensure the dataset size and query time are within limits for the user's PPU (Premium Per User) license. Refresh time < 2 hours. Dataset < 100 GB. Check What is the Microsoft Fabric Capacity Metrics app? - Microsoft Fabric | Microsoft Learn
Configure Retry Policy in Power BI Service. Power BI automatically retries refresh failures once. You can also manually trigger a retry after a failure.
Please go through the below link for more information:
Monitor and optimize on-premises data gateway performance | Microsoft Learn
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.
Thanks a lot.
Error message is posted in the first topic and is too generic to be useful.
Tested with MySql Workbench and all ok.
Using Import Mode but can't switch cause of customer needs.
Checked in error log and no errors.
Checked slow query and nothing.
Checked max connection and its 151.
We are not using on-premises data gateway.
We have configured retry policy to 4 attempts but fails all.
Refresh time is 1 hour and dataset is approx 6MB.
There is a way to get a detailed log from the Service version? Not the Desktop one.
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,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
