Scheduled refresh fails occasionally

Question

Greetings to community,I have a problem with scheduled refresh (Postgres database source) - it fails apx. 50% of the time.Installations on the server:Postgres databasenpgsql 3.1.8on-premise Data Gateway (Power BI)Scheduled refresh in powerbi.com is set up once a day at 10pm. Sometimes refresh completes successfuly, other times it fails with error message:&nbsp;Unable to connect to the data source undefined.Underlying error code:-2147467259 Table: pbi_notifications_view.Underlying error message:PostgreSQL: Exception while reading from streamDM_ErrorDetailNameCode_UnderlyingHResult:-2147467259Microsoft.Data.Mashup.ValueError.DataSourceKind:PostgreSQLMicrosoft.Data.Mashup.ValueError.DataSourcePath:db. [ hidden server name] .sk:5432; [ hidden db name ]Microsoft.Data.Mashup.ValueError.ErrorCode:-2147467259Microsoft.Data.Mashup.ValueError.Message:Exception while reading from streamMicrosoft.Data.Mashup.ValueError.Reason:DataSource.ErrorCluster URI:WABI-EUROPE-NORTH-B-redirect.analysis.windows.netActivity ID:00bf7eb8-391c-4e01-96b2-32c5315f5e1bRequest ID:d3f25655-d504-4d99-bef2-a174431a03d7Time:2019-05-14 20:27:30Z&nbsp;I tried to look for similar error messages on the web with little success. Could you please help me identify source of this error? (it happens only half of the time)

v-cherch-msft · Accepted Answer

Hi&nbsp;devM&nbsp;
I would suggest you restart the gateway to check if the issue persists. If it still persists,you could try to open a support ticket. If you have a Pro account it is free. Go to&nbsp;https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

To stop the service, run this command:
''' net stop PBIEgwService '''

To start the service, run this command:
''' net start PBIEgwService&nbsp;

Regards,

Forum Discussion

Scheduled refresh fails occasionally

2 Replies

Related content

Schedule refresh

Schedule refresh

Refresh/ Scheduled Refresh sudddenly disabled

Scheduled Refresh Failure

PBI Report Server Schedule refresh

Underlying error code:	-2147467259 Table: pbi_notifications_view.
Underlying error message:	PostgreSQL: Exception while reading from stream
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:	PostgreSQL
Microsoft.Data.Mashup.ValueError.DataSourcePath:	db. [ hidden server name] .sk:5432; [ hidden db name ]
Microsoft.Data.Mashup.ValueError.ErrorCode:	-2147467259
Microsoft.Data.Mashup.ValueError.Message:	Exception while reading from stream
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error
Cluster URI:	WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID:	00bf7eb8-391c-4e01-96b2-32c5315f5e1b
Request ID:	d3f25655-d504-4d99-bef2-a174431a03d7
Time:	2019-05-14 20:27:30Z