Forum Discussion
PostgreSQL: Exception while reading from stream
Hi rajendraongole1 ,
Thank you for responding.
When I tried giving a value (100) in the 'Command timout' under 'Advance options', Power BI is able to retrieve the data but it took more than an hour. But when I run the same query in DBeaver, it just took a minute to retrieve the data.
I am not really sure about what is causing the issue in this case.
Thank you!
Super UserHi Sorrowless - Try to simplify your Power Query transformations if possible, or ensure they’re pushed directly to the database using query folding. You can check query folding by right-clicking on a step in Power Query and seeing if the "View Native Query" option is available. Ensure that network connectivity is stable. You might also try connecting Power BI to PostgreSQL via a VPN if latency is an issue.
very important: If your dataset isn't too large for Power BI's memory limits, try switching to Import mode.
Try updating the PostgreSQL driver that Power BI uses. You can download the latest version of the PostgreSQL ODBC driver or switch to an alternative PostgreSQL connector if available.
Review and optimize your query directly within PostgreSQL. If possible, add indexing or optimize joins and filtering. This can sometimes drastically reduce the time required to retrieve data, even from external tools like Power BI.
hope the above suggestions helps. Check for any known issues with the current Power BI Desktop version and consider updating or rolling back to a previous version to see if performance improves.
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn