Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |