Azure Analysis Services

Do you have an idea or suggestion based on your experience with Analysis Services? We would love to hear from you! Please take a few minutes to submit your idea, or vote up an idea submitted by another customer. All the feedback you share in these forums will be monitored and reviewed by the Analysis Services engineering team. By suggesting or voting for ideas here, you will be among the first to know when it gets done.

Please remember this is only for feature suggestions and ideas! If you have technical questions, please submit a question to our MSDN forum. Azure Analysis Services shares the forum with SQL Server Analysis Services due to same modeling, management tools, etc.

If you need support, please open a support ticket through the Azure Portal.

  1. Support Always Encrypted Columns for Azure SQL Database

    It would be great to support the use of Azure SQL Database Always Encrypted Columns in Azure Analysis Services. One scenario could be decrypting while importing (or reading via direct query), another advanced scenario might be storing the encrypted data and de-crypting when reading from AAS.

    19 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  2. Import Power BI Datamodels (pbix, Power Bi Service ) into Azure Analysis Services (successor of Web Designer)

    The Azure Analysis Services Web designer was discontinued on March 1, 2019, leaving no option to import Power Bi desktop Files (pbix) or Datamodels from Power Bi service into Azure Analysis Services (AAS) Instance. Therefore respective new functionality is required.

    17 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. How to perform Load testing on Azure Analysis Services

    A load testing where a same query would be fired on AAS tabular model concurrently which would the give us the metric of query execution time and AAS support load count.
    This testing need to be performed. Any guidance on this.

    16 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. 16 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Feature to alert about insufficient memory or server unavailable

    Can you please provide a feature which can send an alert notifying about insufficient memory for analysis server pricing tier , unavailability of server with the reason.

    16 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. In SSDT's Tabular Model Explorer, arrange measures according to their display folders

    This one's pretty straight forward, the current experience for managing measures in each table becomes "clunky" when you start hitting more than >100 measures. While low priority, it'd be nice to change up this experience and organize the measures into folders for a better management experience.

    15 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Enable user mapping - multi domain

    On a SSAS connection in the Power BI service, we can easily map end-users from different domains to the AD of the SSAS.
    With SSAS on Azure, we're stuck to the default AD, which is blocking several scenarios.
    Please add this flexibiliy to (e.g. by adding this mapping functionality)

    15 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  8. Automate On-premise gateway installation

    We're looking for a way to automate the install of the on-premise gateway to allow it to scale through automation. Passing parameters for Email, Gateway name, Recovery key, pass the recovery key to KeyVault, etc.

    14 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Support ability to get the logs of queries, users who executed them, and time it took for queries to run on my AAS instance

    Would like the ability to get the logs of queries, users who executed them, and time it took for queries to run on my AAS instance. I would like to keep track of this data so I can see if read performance gets worse, which users use the AAS instance the most, and which kind of queries users run so I can optimize for them, for example.

    14 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add support for service principle authentication

    I'd like to be able to refresh cube partitions from within data factory.

    I've got an Azure Batch process that runs a class using the AMO library, however the authentication options are limited - I can either hard code an AD username and password into the connection string, or run the application from an authorised account (which I don't think is possible in azure batch).

    Support for more forms of authentication would enable cube refreshes from data factory / azure batch.

    14 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

    We do support service principals. The next SSMS will make them a lot easier to set in roles and we also have some client lib changes that will make them easier to use. Now you can use them by getting the token yourself and passing it in as the password on the connection string.

  11. Key Vault for Connection string using secrets

    The Key Vault implementation is widely accepted for security reasons and greatly simplifies the work of rotating / change passwords using secrets. When you have a big number of models this becomes a tedious job if you have hundred of models on top of a data warehouse.

    The super awesomeness would be to be able to configure and entire connection from the secrets. When changing environments (Dev to QA or QA to Prod) would just take changing Key Vaults.

    13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Ability to share common components (tables,perspectives etc) between tabular models

    Having the ability to have a re-usable shared library of components would help to:
    - Reduce the time taken to develop and maintain components used across multiple models
    - Encourage the development of smaller, more focussed models
    - Reduce the memory overhead for common shared objects. For example, where models are hosted within the same Analysis Services instance shared components could be loaded once in a ‘central’ model, this single repository of data could then be referenced by other models hosted within the same analysis services instance.

    We’d need the ability to link the central tables and resulting objects into…

    13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Cover Azure Analysis Services in the HIPAA BAA

    Please add Azure Analysis Services to the HIPAA BAA so we can use it in healthcare software.

    13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  14. Azure Analysis Services add Firewall option

    Firewall option for Azure Analysis Services (SaaS) is not available. It would be very helpful to convince some of the customers that is skeptical to use SaaS services because of Public Endpoint. Probably can apply the same solution as Firewall on Azure SQL Server.

    13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. Support for SSAS row level filters and column level security combined in the same model

    Currently SSAS 2017 security roles supports either row level filters or column level visibility only at a time. Both type of security at the same role is not supported now.

    Also currently in SSAS the same user cannot be in roles that has row level security in one role, and column level access in another role. Please see the link below for the limitation:
    https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/object-level-security?view=sql-server-2017

    However, there are requirements where users needs to be restricted by row level and column level both at the same time. SSAS should support this.

    12 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Azure Analysis Services Automated Refresh for Excel Online

    Excel Desktop PowerPivot Report connected to Azure Analysis Services Tabular model refreshing the data works in Excel Desktop.
    However, when you publish this workbook to Power BI workspace (from the workbook's ribbon menu > File > Publish > Publish To Power BI) then you try to refresh the data in Excel Online it doesn't work!!!

    Microsoft should fix this limitation otherwise what's the point of having a refresh capabilities for just Excel Desktop PowerPivot.
    We want our end users to be able to refresh powerpivot reports Online.

    12 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add an "Analyze in Power BI Desktop" button to SSDT-Tabular

    Basically the same functionality as the existing "Analyze in Excel" button found in the top icon bar when developing tabular models in SSDT/VS... only tied to Power BI Desktop instead of excel.

    12 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. Databricks

    AAS should be able to connect to the Databricks ODBC server, just like it can connect to HDInsight and just like PowerBI can connect to the Databricks ODBC server.

    10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. Use Analysis Service in Dual mode as i want to do some tables as 'In Memory' and some tables as "Direct Query" implementation.

    I want to improve our PowerBi performance using 'Direct Query' Model so i want to use Analysis Service in Dual mode as i want to do some tables as 'In Memory' and some tables as "Direct Query" implementation to make help in Query Performance .

    10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Azure Analysis Services Model as Data Source in Azure Analysis Services.

    I would like to be able to call an Azure Analysis Services Model as a source for my Azure Analysis Services model. We have models on prem that call each other. I'm trying to shift them to the cloud. But apparently they cannot call each other as sources there.

    10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Azure Analysis Services

Categories

Feedback and Knowledge Base