Unable to add datasource to Power BI Gateway Cluster

[Anonymous]

I get the below error, when i try to add a datasource in a cluster created.

The status code is "400" and it says "Connection String is not supported"
@Gateway @PowerBIData 

[arvindsingh802]

Are you trying to add ODBC connection ?

If yes, add DSN= as prefix in your connection string

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!

[Anonymous]

Thanks for the suggestion.
On doing so, I get a new error :

Can you help with this ?

[arvindsingh802]

Have you created ODBC connection on Gateway server machine ?

If Yes, Make sure you use exact same name as your ODBC connection

if No, create ODBC connection and then add the data source in gateway

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!

[Anonymous]

Yes, I created a system DSN in the same machine as the Gateway , same name as the datasource . The DSN connection is successful there

[arvindsingh802]

Just checking again

Data source name in System DSN	Connection string in Power BI Gateway
xyz abc	DSN=xyz abc

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!

[ChrisRenlund]

@Anonymous we face the same issue. Did you find any soloution to this?

We have the System DSN configured and working in ODBC Data Source Administrator (64-bit) on the gatewayserver, but when trying to add the datasource to the gateway in Power BI service we get:

Unable to create data source. Connection string is not supported.

Details: [...] On-prem Gateway: The connection string is not supported

[...]

Cluster URI: https://api.powerbi.com

Status code: 400 

System DSN from gateway server is referred to in the Connection String.

[ChrisRenlund]

We added the datasource directly to the gateway, not through "Add to gateway" from a dataset. Then it worked 😵 . And we're able to use it to map credentials for the original dataset.