Forum Discussion

Jayendran's avatar
Jayendran
Solution Sage
6 years ago
Solved

PowerBI Gateway: Connection string is not supported

Hi all,

 

I've tried to setup a new ODATA as the data source in my gateway and got the error like Connection string is not supported

 

 

 

My Gateway Version is Nov version 3000.14.39

 

But the same ODATA is working from the Internet Explorer and Google chrome from the gateway server ! So I don't have any clue why this error is only coming from gateway !

Need Help
  • Jayendran's avatar
    Jayendran
    6 years ago

    Hi GilbertQ / v-xuding-msft ,

     

    It looks like we have a problem with the ODATA. The odata is taking long time to load in IE which leads to getting timeout from the gateway. 

     

    So we are going to reach out to the network and odata team to find why it's taking long time to load this odata.

     

    Thanks all for your help

7 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    Could you please explain when you say it is working from the IE and Chrome Gateway?
    • Jayendran's avatar
      Jayendran
      Solution Sage
      6 years ago

      Hi GilbertQ ,

       

      I mean to say the same ODATA is working fine when I access it from the chrome / IE browser 

       

      IEChrome

      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago
        I would suggest to make sure that the feed works via Chrome as IE depending on the version gives a lot of issues.
  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi Jayendran ,

    Suggest you to install the latest version (3000.21.18 12/26/2019) of gateway firstly. Sometimes, issues can occur when the gateway version is out of date. 

     

    Best Regards,

    Xue Ding

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

    • Jayendran's avatar
      Jayendran
      Solution Sage
      6 years ago

      Hi v-xuding-msft .

       

      I've updated the gateway and now getting timeout issue. I can able to collect the logs from the gateway machine. Please see below

       

      Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessHostingException: A problem hosting the mashup engine was detected. Reason: Timeout. Error code: -2147467259.; ErrorShortName: MashupDataAccessHostingException[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(MashupHostingException)[ErrorCode=-2147467259,HResult=-2147467259]


      Timeout expired. The timeout period elapsed prior to completion of the operation.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Jayendran is this error code different from the problem you resolved?

     

    Unable to create connection for the following reason: Connection string is not supported.

    Details: Marquian's updates: The connection string is not supported Please have this information handy if you choose to create a support ticket. ActivityId: 3c6dcaa6-e964-4a77-8df1-2d5411c32c15 RequestId: b5d5c19d-9e92-4cfb-a184-a3235c782b7b Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed Jun 14 2023 14:20:42 GMT-0400 (Eastern Daylight Time)