Hi! I´m new to scheduling refreshes in Power BI and am experiencing some issues.
I am currently pulling data from a rest api into PBI using python scripts. I have then decided to use a personal gateway to schedule refreshes daily. However, I have always received this error:
An error occurred while processing the data in the dataset.
Refresh failed:
Pexapark automated data has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
{"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":"<ccon>ADO.NET: Python script error.\r\n<pi>Connection Error, retrying in 0 seconds\r\nhttp.client.RemoteDisconnected: Remote end closed connection without response\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nurllib3.exceptions.ProtocolError: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nrequests.exceptions.ConnectionError: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))\r\n</pi></ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Python"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon>Python</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.ExceptionType","detail":{"type":1,"value":"Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException"}},{"code":<ccon>"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Python script error.\r\n<pi>Connection Error, retrying in 0 seconds\r\nhttp.client.RemoteDisconnected: Remote end closed connection without response\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nurllib3.exceptions.ProtocolError: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nrequests.exceptions.ConnectionError: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))\r\n</pi>"</ccon>}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Generation per Production type, Daily.
The error tells me that i have an issue when trying to connect to an external data source via Python.
To attempt to fix this I have imposed ratelimits and uniinstalled and installed my personal gateway again. I have also run the specified problematic python script manually outside of PBI to great success. There are no network issues.
Does anyone know how to prevent the connection aborting?
Many Thanks,
E
