2

I am trying to use Azure Analysis Service in Preview as of today from Microsoft. I have created a new Azure analysis service instance in Azure portal. But when I tried connecting to this instance from SSMS/VS/PowerBI - it fails to connect with UnAuthorized error.

Can someone suggest/help if missing anything or of an limitation ?

I am trying to login with AAD account which is added as admin.

Thanks Sumeet

GregGalloway
  • 11,355
  • 3
  • 16
  • 47
sang
  • 21
  • 3

2 Answers2

3

Make sure you have installed the latest SSMS. This documentation page shows how to connect.

To connect live in Power BI service use the latest Power BI Desktop and then publish to the Power BI service.

To deploy a model to Azure AS use the latest SSDT.

GregGalloway
  • 11,355
  • 3
  • 16
  • 47
1

Clear out any cached credentials by navigating here: 

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

and deleting all files - or at least those that appear relevant.

If that does not work, download SQL Server Management Studio 17.<latest> which appears to have a far better sign in experience for Azure Analysis Services.

You can find more info here

Murray Foxcroft
  • 12,785
  • 7
  • 58
  • 86