Forum Discussion

kellzp22's avatar
kellzp22
Frequent Visitor
5 years ago
Solved

OBDC data refresh error: too many connections for role (gateway error)

Hello. I'm trying to refresh an OBDC data source using an On-Premises Gateway (standard mode). Unfortunately I am experiencing the following error message: ODBC: ERROR [08001] FATAL: too many connections for role. I have already followed the instructions available here: 

https://community.powerbi.com/t5/Service/Disable-parallel-loading-of-tables-in-web-published-report/m-p/664973#M65686 and I can get the data to refresh fine using the Personal Mode gateway..... any ideas :(?? I'd like to use the standard mode so other people can also refresh reports.

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi kellzp22 ,

    In some cases, on-premises gateway doesn't support OAuth type authentication, only personal gateway can be used. It depends on the type and source of the data source.

     

    Here is a similar case, which provides a solution and can be used as a reference first: Solved: Schedule Refresh with ODBC Source - Microsoft Power BI Community

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Is this an import mode or direct query connection?

    • kellzp22's avatar
      kellzp22
      Frequent Visitor
      5 years ago

      I'm not sure how to check this on Service... but desktop confirms import mode (i'm assuming Service would be the same??).

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi kellzp22 ,

    In some cases, on-premises gateway doesn't support OAuth type authentication, only personal gateway can be used. It depends on the type and source of the data source.

     

    Here is a similar case, which provides a solution and can be used as a reference first: Solved: Schedule Refresh with ODBC Source - Microsoft Power BI Community

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.