Hi all,
we have set up a number of PBI datasets (about a dozen) on PBI Online that are scheduled to update on a daily basis. All these datasets refer to a Postgres database we host ourselves at a rented VM.
However, we receive error messages about these automatic updates sporadically, but with a too high frequency (multiple per week). These error messages say:
An error occurred while processing the data in the dataset.
Refresh failed:
<Report name> 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":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"An error happened while reading data from the provider: 'Connection is not open'"}}],"exceptionCulprit":1}}} Table: public <table_name>.
This happens for multiple different datasets and different tables in the Postgres database. How can we trace down these sporadic issues? Manual access to the database works fine. What does this error message tell us in detail, I could not find it on Google? Is there any way to turn on logs either on the PBI or the Postgres site?
Thanks in advance,
Christoph Thiede
