Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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" }
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |