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 

 

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