Error refreshing on desktop and service

Hello Iaguas 

A list of possible solutions for you to try!!

• Confirm the PostgreSQL server is online and accessible.

• Verify credentials and permissions haven’t changed.

• Test the connection in Power BI Desktop → Data source settings → Test Connection.

• Ensure VPN, SSL, or firewall isn’t blocking Power BI.

• Large tables or queries returning huge datasets can cause streaming issues.

• Try filtering the data (e.g., limit rows to 1000) and see if it refreshes.

• Consider query folding or pre-aggregating data in the database before loading.

• Ensure the PostgreSQL ODBC/Npgsql driver is up-to-date on your machine.

• Power BI recommends using the latest Npgsql driver for PostgreSQL.

• Mismatched or old drivers can cause stream read errors.

• Increase the data load timeout in Options → Data Load → Timeouts.

• Temporarily disable background data to see if refresh succeeds.

• If using an on-premises gateway, check that the gateway version is latest.

• Ensure the gateway can connect to the PostgreSQL server.

• Check network stability interruptions can cause stream exceptions.

• Complex transformations in Power Query can break query folding.

• Review applied steps in Power Query and try simplifying transformations.

• Test if simpler queries refresh successfully.

• Enable diagnostic tracing in Power BI Desktop: File → Options → Diagnostics → Enable tracing.

• Split large tables into smaller chunks.

• Use incremental refresh instead of full refresh.

• Consider using DirectQuery mode instead of Import, if feasible