Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
When calling
[POST] "https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/Default.SetAllConnections"
with json body
{
"connectionString": "(description=(address=(protocol=tcp)(host={ip})(port={port}))(connect_data=(service_name={name})))"
}
Server a error:
"error": {
"code": "InvalidRequest",
"message": "Connection string is not valid"
}
But same connection string is used by Power BI Desktop and Gateway.
Solved! Go to Solution.
@marciomyst wrote:
When calling
[POST] "https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/Default.SetAllConnections"
with json body
{
"connectionString": "(description=(address=(protocol=tcp)(host={ip})(port={port}))(connect_data=(service_name={name})))"
}
Server a error:
"error": {
"code": "InvalidRequest",
"message": "Connection string is not valid"
}
But same connection string is used by Power BI Desktop and Gateway.
The connection string is not correct. You can get the expected connection string by calling Get Datasources. An expected connection string can be as simple as
{ "connectionString": "data source=oracleservername;persist security info=True" }
When calling
[POST] "https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/Default.SetAllConnections"
with json body
{
"connectionString": "(description=(address=(protocol=tcp)(host={ip})(port={port}))(connect_data=(service_name={name})))"
}
Server a error:
"error": {
"code": "InvalidRequest",
"message": "Connection string is not valid"
}
But same connection string is used by Power BI Desktop and Gateway.
@marciomyst wrote:
When calling
[POST] "https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/Default.SetAllConnections"
with json body
{
"connectionString": "(description=(address=(protocol=tcp)(host={ip})(port={port}))(connect_data=(service_name={name})))"
}
Server a error:
"error": {
"code": "InvalidRequest",
"message": "Connection string is not valid"
}
But same connection string is used by Power BI Desktop and Gateway.
The connection string is not correct. You can get the expected connection string by calling Get Datasources. An expected connection string can be as simple as
{ "connectionString": "data source=oracleservername;persist security info=True" }