Power BI refresh failure

[iulian_buhat]

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)

• Underlying error messageMySQL: Fatal error encountered during data read.
• DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
• Microsoft.Data.Mashup.ValueError.DataSourceKindMySql

[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

[iulian_buhat]

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.

[Icey · Accepted 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