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

     

     

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.

      • 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