Refresh Power bi service gateway ODBC mysql issue

[Simomazzi]

Hi,

I am experiencing a recurring issue with Power BI Service while refreshing a dataset connected via an on-premises data gateway using an ODBC connection to MySQL. The refresh process fails after approximately 2 hours with an "Out of Memory" error:

ERROR [HY000] [MySQL][ODBC 9.2(w) Driver][mysqld-8.0.41] MySQL client ran out of memory

Interestingly, the same dataset refreshes without any problems in Power BI Desktop, which suggests that the issue might be related to the gateway configuration or resource limitations on Power BI Service.

The RAM capacity is the same in both cases.

Could you please assist me in diagnosing and resolving this issue? 

Thanks a lot.

[Simomazzi]

Hi @v-kpoloju-msft , this is the solution. Thanks

[v-sdhruv]

Hi @Simomazzi ,
Just wanted to follow up if you have tried working out with the given solution.
If you are still facing the issue, you can try visiting this link below where a similar issue was encountered and solved.

https://community.fabric.microsoft.com/t5/Desktop/ERROR-HY000-MySQL-ODBC-8-0-w-Driver-mysqld-5-7-32-...

Hope this helps!

[lbendlin · Accepted solution]

Have you considered using incremental refresh? Or is your query not folding?

The RAM capacity is the same in both cases.

Have you configured the gateway service to actually use most all the RAM?  You may need to specify that manually.

      <setting name="MemoryUtilizationPercentageThreshold" serializeAs="String">
        <value>95</value>
      </setting>

Can you double the memory of the gateway VMs?