Getting started

Sign in to queue

Description

High level overview of Microsoft's Azure Analysis Services, which is part of Microsoft's overall BI offerings to help organizations gain insights from their data.

Embed

Download

Download this episode

The Discussion

  • User profile image
    Isham Mohamed

    Unable to connect to the service with Power BI - October update.

  • User profile image
    sang

    Hi, 

    I am not able to connect to Azure analysis service instance from SSMS or not able to deploy tabular project from Visual studio.

    Even from PowerBI desktop , not able to connect to this new Azure analysis service instance.

    Do we need special account for login to AAS. AAD account is added in Admin blade.

    Please let me know if I am missing anything?

    Thanks

    Sumeet

  • User profile image
    ColinMurphy

    Hi Sumeet,

    You will need the latest versions of SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) to connect to Azure Analysis Services. I'd recommend going to the community forums and feedback site for Azure Analysis Services information. Here are the URLs:

    https://feedback.azure.com/forums/556165

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=AzureAnalysisServices

     

    Regards

    Colin

     

     

  • User profile image
    sang

    @ColinMurphy: Thanks Collin, with  latest worked.

    I am able to deploy tabular model project to azure analysis service using sql azure.

    But I want to retrieve data from tabular model using DAX query - what would be format of connection string to connect to azure analysis service to query data.

     

    Thanks!

     

  • User profile image
    Bhavin

    How many analysis service database can be deployed to one Azure AS instance

Add Your 2 Cents