Trying to connect to SSAS to connect to a PBI workspace in SSMS

Question

Trying to connect to sql server analysis server for the first time to view datasets under a workspace but when i'm setting up my connection with Active Directory - Universal with MFA support authentification i'm getting the following error message:

TITLE: Connect to Server
------------------------------

Cannot connect to powerbi://api.powerbi.com/v1.0/myorg/Test.

------------------------------
ADDITIONAL INFORMATION:

The integrated security 'ClaimsToken' is not supported for native connections. (Microsoft.AnalysisServices.AppLocal.AdomdClient)

score 1 · Accepted Answer · answered May 02 '21 at 20:33

1

Have you tried Windows Authentication instead? It looks like you might be having the same issue: SSAS claimsToken is not supported

answered May 02 '21 at 20:33

sbgdata

46
4

I get the following error: The connection string is not valid. – Roger Steinberg May 02 '21 at 23:12
Which SSMS version are you using? – sbgdata May 03 '21 at 01:22
i'm running version 17.6. – Roger Steinberg May 03 '21 at 03:33
3

You would need SSMS version 18.8 or higher (source: https://learn.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools) – sbgdata May 03 '21 at 07:27

Trying to connect to SSAS to connect to a PBI workspace in SSMS

1 Answers1