Pulling data into Powerpivot from an Azure SSAS tabular model

  • Paulo de Jesus

    Ten Centuries

    Points: 1392

    I have SSAS (Preview) as a service in Azure.
    Connecting to the tabular model from the Power BI Desktop app is fine and I am able to pull the data.
    The problem is when trying to connect to the same tabular model from Excel 2016 Powerpivot.
    The username is an Azure AD account which uses two-factor auth.
    I have also tried another Azure AD account without two-factor auth, but I am still unable to connect.
    Are there any "GOTCHAs" that I should be aware of?

    Kind regards
    Paulo

  • Martin Schoombee

    SSCoach

    Points: 19010

    Yes...if you're using 2-factor authentication in Azure, you need to set up an app password as Power Pivot may not support 2-factor authentication natively. See the following: https://docs.microsoft.com/en-us/azure/multi-factor-authentication/end-user/multi-factor-authentication-end-user-app-passwords

  • Paulo de Jesus

    Ten Centuries

    Points: 1392

    Thanks Martin

    I will give it a try and see if it resolves the issue.

    Kind regards
    Paulo

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply