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

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI GilbertQ

Thanks for replying. so i have to change 8 to 1 ?

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    Yes if you could change that and see if it then works?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I tried and changed to 1 but it takes too much time to get refreshed and did not complete refresh 

      • 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.