Forum Discussion

Iaguas's avatar
Iaguas
Frequent Visitor
1 year ago
Solved

Error refreshing on desktop and service

My report stopped refreshing on desktop and service, displaying the following errors respectively: "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Err...
Need Help
  • NimaiAhluwalia's avatar
    NimaiAhluwalia
    1 year ago

    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

     

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi Iaguas  , 

Thanks for reaching out to the Microsoft fabric community forum. 

This error usually happens when the connection between Power BI and PostgreSQL is interrupted. A few quick checks that often solve it:

  • Make sure the PostgreSQL server is reachable and your network/firewall isn’t blocking the connection (whitelist the IP if needed).
  • Update the PostgreSQL/Npgsql driver on both Desktop and the gateway.
  • If you’re using a gateway in the Service, confirm it’s updated and connected.
  • Try reducing the data being pulled (filter rows or simplify the query) to see if it refreshes.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

 Best Regards, 
Community Support Team  

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Iaguas  ,

    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

    Best Regards, 
    Community Support Team 

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi @Iaguas  ,

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

      Best Regards, 
      Community Support Team 

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi Iaguas ,

        Can you please confirm whether the issue is sorted or not.

        Thank you.