Forum Discussion
DataLoad
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
3 Replies
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.
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.
