Repetitive MySQL: Fatal error

[Anonymous]

Hello everyone ! 

I created and published a powerBi report that accesses a database through a on-premise daat gateway.

It has been working fine for some time, but now it is showing MySQL errors repeatedly: 

MySQL: Fatal error encountered during data read.

I know that the Gateway is not being overwhelmed, as I limited the MashupDefaultPoolContainerMaxCount.

I also know that the same PowerQuery works on smaller databases withe the same structure.

My intuition is that the database is being flooded by requests and it can't process it all.

I can't prove it right or wrong because I do not have access to database logs / utilization.

Is my intuition right, or should I test something else ?

I am currenty trying to fine-tune the PowerQuery so it sends less requests to the database. 

Do you have any other tips to help me ?

Thanks in advance for your answers

Have a great day 

[Anonymous]

Hi @Anonymous ，

I think you can go with your gut first and try to call a small dataset for validation and if the problem cannot be solved you can try the suggestions I gave you.

1.You can troubleshoot the following whether it is caused by query timeout, you can connect to the data source is, set the command supermarket and connection timeout.

2.You can also set incremental refresh, incremental refresh can not refresh all the data, only need to refresh the data you want to change, can reduce the amount of data to refresh and database load.

The following documentation related to incremental refresh is helpful:

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you for your answer ! 

It seems that the database is being overloaded.

I increased the connection timeout to 1h, but It didn't really change anything.

Sadly I can't implement incremental refresh on this dataset.

I guess I'll have to rewrite the PowerQuery to get it working again.