Error on refresh with PSQL

[BraulioLopez]

Hi,

I'm experiencing issues with the refresh of our datasets.

I tried multiple things to get it fixed but none of them works, updated NPGSQL, WINMTR to the database, updated the gateway to latest versions. This issue with the database only happens with PowerBI our external process never have this error.

Detalles del error: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"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":"<ccon>PostgreSQL: ERROR: 57014: cancelando la sentencia debido a una petición del usuario</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"PostgreSQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon><ip>xxx.xxx.xxx.xxx</ip>;bidb</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"ERROR: 57014: cancelando la sentencia debido a una petición del usuario"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: vehiculos_gdc.

[Anonymous]

Hi @BraulioLopez ,

According to your description, when you refresh your dataset , it may return the "DM_GWPipeline_Gateway_TimeoutError" error code .

For this issue , you can check this:
(1)Whether the latest version of the data gateway is installed.

(2)Is your dataset in a shared capacity or a premium capacity? If the maximum refresh limit is 2 hours for shared capacity, 5 hours for Premium capacity. If you want to refresh successfully on Power BI Service, you need to control the amount of your data.

(3)If you face the "command timeout error" , you can refer to this case:
Solved: How to set command timeout option - Microsoft Power BI Community

(4)Check whether the gateway computer has sufficient memory and CPU resources when you refresh it.Try to reduce the amount of data for refreshes to test whether too much data is causing too much resource consumption, resulting in timeouts.

I have also found some similar posts, please refer to.

Solved: pbi api refresh internal service error - Microsoft Power BI Community

Solved: Dataset refresh fails due to internal server error... - Microsoft Power BI Community

If it still 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.