topic Default.SetAllConnections fail for Oracle Connection String in Developer

Default.SetAllConnections fail for Oracle Connection String

marciomyst — Tue, 17 Oct 2017 10:25:10 GMT

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.

Default.SetAllConnections fail for Oracle Connection String

marciomyst — Mon, 16 Oct 2017 16:13:55 GMT

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.

Re: Default.SetAllConnections fail for Oracle Connection String

Eric_Zhang — Fri, 20 Oct 2017 09:10:10 GMT

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