Forum Discussion
General dissatisfaction and performance issues
Hi All, After having our tech guys setting up a PostgreSQL database for me to build our datawarehouse on it, i have done all the automation that dumps the data from our main MongoDB to the dataw...
You should use a different database. :)
Honestly, it is very likely the connector to PostgreSQL that is at fault here. That same amount of data in SQL Server or Azure SQL DB would import in minutes. That being said, I have no idea about your network infrastructure, storage, etc. so too many factors to isolate the cause. But, it might be worth spinning up an Azure SQL DB or SQL Server on an MSDN or development license. You can get a 30-day free trial of Azure SQL DB. Load your data and try it. If the performance is great, at least you know it really is Power BI's connector to PostgresSQL.