Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Postgresql shows refreshing error with Power Bi

HI  I have Postgresql connection with Power Bi and it gives me below error while refreshing desktop version   "OLE DB or ODBC error: [DataSource.Error] PostgreSQL: 53300: too many connections for ...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi Anonymous 

     

    It appears that the PostgreSQL does not like so many connections.

     

    You can change how many connections run at one time by going into the settings in PBI Desktop and changing it as shown below to 1 for Simultaneous connections

     

     

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi Anonymous 


Thanks for the update.


If this is the case I would chat to your DBA to see how they can increase the number of concurrent connections to resolve this.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I do not know but I escalated to IT dept and they increased no of connection. and Problem solved but my team can not get refreshed result on web version

 

But thanks for your support