Forum Discussion
General dissatisfaction and performance issues
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.
Thanks Greg_Deckler.
I think i will test Azure.
My question now is: why advertising something as if it works flawlessly when it clearly doesn't?
Had i knew about these issues previously, the whole setup would have been different. Now i'm in the middle of a new job with dashboards and reports developed upon something reluctant to work, andwill need to dump the data into another database, change the automations (Talend jobs, Jenkins etc.), all of this in a hurry, and triyng not to look like a total idiot to non technical people in the company.
Not cool.Azure is not an option, too expensive after the first month. Not setting up the whole system only for a month.
Will try something different.
Suspicions are sneaking into my mind though.
This could be my first and last subscription to PBI if what i think is true.
But first, i will test other data sources and the gateway extensively and see if it's only a PostgreSQL problem.Hang on, an Azure SQL DB at $15 or $30 per month is too expensive? And, you can go here: https://azure.microsoft.com/en-us/services/sql-database/ and get the first month free.
