Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
marciomyst
Frequent Visitor

Default.SetAllConnections fail for Oracle Connection String

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.

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

Capture.PNG

View solution in original post

2 REPLIES 2
marciomyst
Frequent Visitor

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.


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

Capture.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors