Desktop working, gateway not working with postgres

[AGo]

Hi,

I've got several problems maybe with the same common root.

In desktop EnableFolding=True is working, an error that pretend EnableFolding=False is returned with the same pbix when on the service refreshing through the gateway.

Then this non-clear error on the dataset refresh

{"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":"PostgreSQL: Exception while reading from stream"}},{"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":"192.9.200.206;poc"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Exception while reading from stream"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}

The dataset fails its refresh always after around 20 minutes

If I try the same query throug dataflows it fails always after around 11 minutes prompting that AzureBlobs didn't receive the answer and the request has been canceled.

What can I do?

Thanks

[Mkara]

Did you try to install the npgsql  4.0.10 and if yes did it solve the issue? 

[v-lili6-msft]

hi @AGo 

You may try to install msi package below.

https://github.com/npgsql/npgsql/releases/tag/v4.0.10

Regards,

Lin

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".