Default.SetAllConnections fail for Oracle Connection String

[marciomyst]

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]

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.

[Eric_Zhang · Accepted 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.

---

@marciomyst

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"
        }