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 202...
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.