Forum Discussion

dhwani's avatar
dhwani
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

POWER BI CI/ CD using the Power BI API

I have Azure Analysis services as my source and I am trying to do CI CD with power shell and Service Principal.

I do not have any gateways as it is not required. Here is the problem.

I am able to update my connection string from DEV to PPE and from PPE to Dev the reports are working. I validated using get- data sources in the group and it is updated and looks good as below.

I do not have any gateway , But what is this gateway ID?

 

{
  "@odata.context": "http://df-msit-scus-redirect.analysis.windows.net/v1.0/myorg/groups/ab5c3fad-3dc1-4ace-a458-87d7712682d0/$metadata#datasources",
  "value": [
    {
      "datasourceType": "AnalysisServices",
      "connectionDetails": {
        "server": "Proper COnnection String",
        "database": "Proper Name"
      },
      "datasourceId": "Some ID",
      "gatewayId": "SOme ID"
    }
  ]
}

When I am changing the connection string to Prod , my reports are not working and when I tried with get- datasource details the output is different.
There is no datasource ID and gateway ID . what is the isue here?

{ "@odata.context": "http://df-msit-scus-redirect.analysis.windows.net/v1.0/myorg/groups/ab5c3fad-3dc1-4ace-a458-87d7712682d0/$metadata#datasources",
"value": [ { "datasourceType": "AnalysisServices",
"connectionDetails":
{
"server": "Proper COnnection String",
"database": "Proper Name"
},
}
] }

Jayendran Any idea?