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