Forum Discussion
data mashup error
{
- 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.
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
