Scheduled refresh fails occasionally

[devM]

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 database
• npgsql 3.1.8
• on-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:

Unable to connect to the data source undefined.

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

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 solution]

Hi @devM 

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 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 

Regards,

[devM]

Thanks v-cherch-msft, that was it. Restarting the service solved issue with failing refresh.

Although I had to do it via services.msc window rather than console commands.