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.
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:
"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?
"connectionString": "Data Source=asazure://<region>.asazure.windows.net/<your instance>;Initial Catalog=<your database>;Cube=Model"
"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.
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 |