Hey everyone! 👋
Hey everyone! 
I'm running into some trouble connecting to my Neon database from Power BI, and I was hoping someone might have some insights. I'm fairly new to this whole data stuff, so please bear with me if I'm not using all the right terms!
Basically, I'm trying to import data into Power BI, but I keep getting this "PostgreSQL: Exception while reading from stream" error . It seems to start downloading fine, but then it just cuts out after about 5 minutes.
Here’s what I've tried so far (as per suggestions from the Neon support team and other sources):
- Switched from a pooled connection string to a direct one
- Added a custom SQL query to limit the data being imported
- Disabled the "Scale to Zero after 5 minutes of inactivity" feature
I'm not sure if the problem is with Power BI, Neon's configuration, or something else entirely
. I've reached out to both Power BI and Neon support, but haven't heard back yet, so I figured I'd see if anyone here has experienced something similar or has any tips for a newbie.
Any help would be greatly appreciated! Thanks in advance!
I'm running into some trouble connecting to my Neon database from Power BI, and I was hoping someone might have some insights. I'm fairly new to this whole data stuff, so please bear with me if I'm not using all the right terms!
Basically, I'm trying to import data into Power BI, but I keep getting this "PostgreSQL: Exception while reading from stream" error . It seems to start downloading fine, but then it just cuts out after about 5 minutes.
Here’s what I've tried so far (as per suggestions from the Neon support team and other sources):
- Switched from a pooled connection string to a direct one
- Added a custom SQL query to limit the data being imported
- Disabled the "Scale to Zero after 5 minutes of inactivity" feature
I'm not sure if the problem is with Power BI, Neon's configuration, or something else entirely
. I've reached out to both Power BI and Neon support, but haven't heard back yet, so I figured I'd see if anyone here has experienced something similar or has any tips for a newbie.Any help would be greatly appreciated! Thanks in advance!
