Problems creating (Azure) Analysis Services Live Connection Dataset via PowerBI REST API

Anonymous — Tue, 24 Sep 2019 21:00:01 GMT

Hi,

I've been trying to create a Live Connection dataset pointing to Azure Analysis Services via the REST API's:
Push Datasets - Datasets PostDatasetInGroup

First off, it's really nice to be able to test the API calls directly from the documentation page, but ...

It would be nice to have some more info on the Analysis Services options, as this is pretty much undocumented - as noted by @Anonymous here.

So far I've come to conclude that:

The correct default mode might be either one of the below, as per the this post by @jpp , unfortanely the msdn-article referenced by JP is no longer available.
```
"defaultMode": "AsAzure"
or 
"defaultMode": "AsOnPrem"
```
If this is supposed to be 'AsOnPrem' even for AAS, does that mean that a gateway is also required? Also from according to Adam (@GuyInACube ) here the different defaultModes should have an impact on how you authenticate?
The tables element should be an empty array '[]'.
AAS live connection requires a 'connectionString' instead of the connection details, as well as a name and potentially 'datasourceType'.

The ConnectionString should include at least the elements 'Data Source','Initial Catalog', and 'Cube'.

"connectionString": "Data Source=asazure://<region>.asazure.windows.net/<your instance>;Initial Catalog=<your database>;Cube=Model"

If the datasourceType is required, it should as far I can tell be
```
"datasourceType": "AnalysisServices"
```

I've tried the following requests resulting in 401 responses:

{
  "name": "ApiTestAasDataset1",
  "isRefreshable": false,
  "isEffectiveIdentityRequired": true,
  "isEffectiveIdentityRolesRequired": false,
  "isOnPremGatewayRequired": false,
  "datasources": [
  	{
      "datasourceType": "AnalysisServices",
      "connectionDetails": {
        "server": "asazure://westeurope.asazure.windows.net/<myserver>:rw",
        "database": "<mydb>"
      },
      "connectionString": "Data Source=asazure://westeurope.asazure.windows.net/<myserver>;Initial Catalog=<mydb>;Cube=Model;User ID=<myuserid>;Persist Security Info=True;Impersonation Level=Impersonate"
  	}
  	],
  "tables": []
  "defaultMode": "AsAzure"
}

{
  "name": "ApiTestAasDataset1",
  "datasources": [
  	{
      "datasourceType": "AnalysisServices",
      "connectionString": "Data Source=asazure://westeurope.asazure.windows.net/<myserver>;Initial Catalog=<mydb>;Cube=Model;User ID=<myuserid>;Persist Security Info=True;Impersonation Level=Impersonate"
  	}
  	],
  "tables": [],
  "defaultMode": "AsAzure"
}

Anyhow, I hope that at least this post helps other people struggling with this to get stuck at the same point I am... because a burden shared is a burden halved? Also if we do get this figured out this thread could serve as rudimentary documentation in lieu of official examples from Microsoft.

EDIT: This should probably have gone into the Developer section, my bad for not looking at the forum structure closely enough. If any moderators see this and have the ability to move the post, then feel free to do so.

topic Problems creating (Azure) Analysis Services Live Connection Dataset via PowerBI REST API in Developer

Problems creating (Azure) Analysis Services Live Connection Dataset via PowerBI REST API