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

789 Views Asked by At

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)
1

There are 1 best solutions below

4
On BEST ANSWER

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