Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I had connected my PowerBi to our PostgreSQL DB hosted on Heroku. A week ago or so, I started getting timeout errors when loading even the smallest tables.
As far as I can understand, there ist not really a solution for people with timeout issues who are trying to connect to a Heroku database. I am summarizing my understanding of the issue below to try and highlight the problems - if there really is no solution there might be a few relatively simple features that could solve the problem.
I have already posted on this problem here but am opening a separate thread because I view the Heroku case as a separate issue.
Importing data via the "PostgreSQL" option
Importing data via the ODBC option
If anybody has found a solution / seen anything I've missed, would be grateful for your help! I imagine this isn't an uncommon problem, so would be great to find a solution for this specific case.
Thanks,
Dax_Rookie
Hi @Dax_Rookie,
I don't have much more knowledge about Heroku PostgreSQL. Regarding your issue, please try download the latest Power BI desktop version to see if the issue is mitigated. If issue persists, I would suggest you create a support ticket to get dedicated support.
Best Regards,
Qiuyun Yu