Forum Discussion
Desktop working, gateway not working with postgres
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
3 Replies
- Greg_DecklerCommunity Champion
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". - v-lili6-msftCommunity Support
hi AGo
You may try to install msi package below.
https://github.com/npgsql/npgsql/releases/tag/v4.0.10
Regards,
Lin
- MkaraFrequent Visitor
Did you try to install the npgsql 4.0.10 and if yes did it solve the issue?