Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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!
Thanks for the suggestion.
On doing so, I get a new error :
Can you help with this ?
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!
Yes, I created a system DSN in the same machine as the Gateway , same name as the datasource . The DSN connection is successful there
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!
@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.
System DSN from gateway server is referred to in the Connection String.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.