Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Recently we have been struck by an issue with our reports, specifically that the datasets are not refreshing when scheduled. My opinion is that the access to the mysql server is becoming too much for its capability, another is that the hardware on which the gateway is on might be the issue, or that it might be from the query itself. I have checked the storage, and we are far below even with all loaded datasets.
This is the error we have (part of it held back for privacy concerns)
Solved! Go to Solution.
Hi @iulian_buhat ,
So, you've figured out the cause of your issue - too many datasets refreshed at the same time, right?
Best Regards,
Icey
Hi @iulian_buhat ,
Some questions:
1. Can this report be refreshed successfully previously?
2. Can other reports be refreshed successfully?
3. Is your gateway running?
4. Is MySQL running when refreshing?
5. Can you connect to MySQL and refresh in Power BI Desktop now?
Best Regards,
Icey
1, 2. All of the reports can be refreshed successfully and they have, they just fail rather often. Checking the logs, the failures are from timeout.
3. Yes
4. Also yes, it is constantly being updated
5. Just did
The issue seems to be on load for the mysql database, a quick fix would be to time some datasets to refresh at different times to not strain the database.
Hi @iulian_buhat ,
So, you've figured out the cause of your issue - too many datasets refreshed at the same time, right?
Best Regards,
Icey
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.