DataSource.Error: MySQL: Out of memory; check if mysqld or some other process uses all available mem

[Sai_Akash]

Hi BI Team,

I’m encountering an "Out of Memory" error when trying to connect Power BI to my MySQL database hosted on AWS RDS. The error message suggests checking if mysqld or another process is using all available memory, and mentions using 'ulimit' or adding more swap space. Has anyone faced this issue before? If so, what steps did you take to resolve it? Any advice on adjusting memory settings in either Power BI or MySQL would be greatly appreciated.

Regards,
Sai Akash

[v-pagayam-msft]

Hi @Sai_Akash ,
We haven't heard back from you regarding our last response and wanted to check if our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft · Accepted solution]

Hi @Sai_Akash ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum!

Since your question is related to SQL Server, I suggest posting it in the Microsoft Q&A - SQL Server forum, where SQL and external data query experts can assist you.
You can post your query here:

Microsoft Q&A - SQL Server: SQL Server - Microsoft Q&A

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Regards,
Pallavi.

[v-pagayam-msft]

Hi @Sai_Akash ,
If our response helped in addressing the query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you for being a part of the Microsoft Fabric Community Forum!