data mashup error

[Devesh790]

{

• Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [HY000] [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.33-0ubuntu0.20.04.2]MySQL client ran out of memory"}}

Getting this error while updating the data on power bi service.
However when I am limiting my records the data is easily updated.. can any one please help as I cant limit my data.

[Devesh790]

Hi Team,

Thanks for reverting, I have tried as you have said but its not working. 
Further I have updated the machine where Mysql was hosted

[v-rongtiep-msft · Accepted solution]

Hi @Devesh790 ,

Please have a try.

Make sure you have installed 64 bit odbc driver.

2. Try to use MySQL using the latest .net driver -https://dev.mysql.com/downloads/connector/net/

3. Increase memory Management cache in Data Load under -> file -> options and settings -> options

make it 8-10 GB and try

I have also found a similar post, please refer to it to see if it helps you.

Solved: Getting an error message after refreshing data on ... - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

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