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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.