URGENT Help - Service Refresh error

[ApoorvaReddy]

I keep getting below error when i refresh dataset in Service, having a data connection to ODBC PostgreSQL.

{"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 [HY001] Out of memory while reading tuples.;\nmemory allocation error???"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=OneView Payor PostGre"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Pricing Currency.

ANy help would be appreciated.

[poojayenman]

Hi, Have you got any solution for this error? I am also facing the same issue.

@ApoorvaReddy 

[Anonymous]

Hi, I got the exactly same error as you get all the time. Did you solve this issue? Thank you!

[V-lianl-msft]

Hi @ApoorvaReddy ,

If your issue occurs frequently and you need additional help, you could have a support by creating a ticket in Power BI support( if you are a Power BI Pro).

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

[Anonymous]

Restart your gateway and hit refresh again

[lbendlin]

Use less memory, or increase the available memory on your database server.