Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Gateway Issue

  Description: We are encountering a recurring issue with our Power BI gateway. The error message we're receiving is: Data source error: {"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderOpen...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Est-ce que MS a vous fourni une posible solution pour le probleme de mise a jour :

Erreur de source de données: {"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError"

NickMac's avatar
NickMac
Frequent Visitor
2 years ago

Hi all,

 

Just following up. Getting Management approval to spend another $1800 a month on 2 additional gateways for our cluster. Bringing the total number of gateway servers in the cluters to 4.

MS is suggesting that by scaling horizontally we have enough threads to meet the demand and reduce the incidence of this issue. 

Will report back on this thread once implemented and running for some days to see if there is a measurable benefit for the additional cost.

 

Nick Mac

  • johnh35's avatar
    johnh35
    New Member
    2 years ago

    Hi Nick, are you using virtual gateways?

    • NickMac's avatar
      NickMac
      Frequent Visitor
      2 years ago

      No, on-premise gateways. Setup with multiple 8vpu servers.