Power BI connection to Postgres dropping

Question

I am trying to connect my Postgress DB source (hosted on AWS) with my Power BI desktop client. The table size is big which I am trying to pull (more than 30 Million records). When connecting via Import Mode, after pulling few thousands of record, the basic load operation throws an error -
'Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] PostgreSQL: Exception while reading from stream.
'.'

I tried increasing the command timeout parameter to 1hr as well, but didn't help. I am not sure what is the root cause of this behavior. Although I had got success with the same table in the past but the refresh fails now to that table.

Answer 1

Hi @Khare, Soamya (uib05461) ,

PowerBI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated PowerBI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

----------

(If the reply was helpful please don't forget to upvote or accept as answer, thank you)

Best regards,
Leon

Answer 2

Hi @Khare, Soamya (uib05461) ,

Please try writing native query with select * and where clause (used parameter). Hope it will work

Thanks,