Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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" }
User | Count |
---|---|
16 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |