DataLoad

[Anonymous]

Hi 

we are using postgress DB and the have DB 40 millions records,

and  i filtered the data with where conditions and Limit,

Bubt it can't load more than 5lakshs recordsin Power bi Desktop(May 2021),

can you please helpme on this.

Thanks In Advance

Regarda

Ramesh

[Anonymous]

Hi @Anonymous ,

The problem generally seems to be with the Postgresql driver. 

Please check the following URLs for some suggestions for ODBC driver - 

• https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4498d4f2-9646-4921-b56d-79e22c14a215/import-data-from-postgresql-into-sql-server-2005
• https://stackoverflow.com/questions/22532149/vba-and-postgresql-connection
• https://www.ibm.com/support/pages/odbc-s1001-hy001-memory-allocation-failure

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt there is any such limitation.

is it giving any error. Open power query and check. Usually some error is shown in yellow

You can also try the direct query option.

[Anonymous]

Hi amit

i am getting below error

ODBC :ERROR[HY001]out of  memory while reading tuples;Memory aloocation error

Regards

Ramesh