PowerBI Gateway: Connection string is not supported

[Jayendran]

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 !

[Marquian]

@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)

[v-xuding-msft]

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]

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.

[GilbertQ]

Hi there

Could you please explain when you say it is working from the IE and Chrome Gateway?

[Jayendran]

Hi @GilbertQ ,

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

IEChrome

[GilbertQ]

I would suggest to make sure that the feed works via Chrome as IE depending on the version gives a lot of issues.

[Jayendran · Accepted solution]

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