Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Greetings to community,
I have a problem with scheduled refresh (Postgres database source) - it fails apx. 50% of the time.
Installations on the server:
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)
Solved! Go to 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,
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,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.