Deploying Tabular cube to Azure Analysis services

1
votes

I am trying to deploy our cube to Analysis services. However it is giving us a permissions issue error as shown below:

Deployment error

I am getting the and setting the servername from azure portal and setting it in properties in SSDT as follows:

enter image description here

enter image description here

Also I was reading and it seems that Analysis services uses Windows Authentication to deploy and you can set this permission by connecting through SSMS. However when trying to connect through SSMS i was having another issue to connect which I am posting as a separate question. The link is as follows:

2
sql-serverssassql-server-data-toolsazure-analysis-services

2 Answers

0
votes

Authentication with Azure Analysis Services is still quite fiddly.

Here is what we do:

  1. Install the latest SQL Server Management Studio (SSMS). By latest I mean including previews Currently at SQL SSMS 17.0 RC3.

  2. Install the latest version of SQL Server Data Tools (also the RC). Currently at SQL SSMS 17.0 RC3

Then, clear out any cached credentials by navigating here: 

C:\Users\<your username>\AppData\Local\AADCacheOM

You can find more info here

0
votes

AAS Security is slightly different. There is a specific place to add admins that differs from other PaaS in Azure.

enter image description here