sqlssmsssasxmla

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


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)

Solution

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