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. 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.

    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 →
  2. 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.

    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 →
  3. Support default dimension members in tabular models (like multi-dimensional SSAS can)

    Please consider defining default dimension selections/members so that if users don't select a value from a dimension table, all measures behave as if they selected a particular value. Examples are Currency Conversion (USD would be default). We are having to build this default behavior into ALL of our measures using DAX.

    And if you have multiple dimensions that you want to have default selections for, this causes the DAX to become larger and less supportable.

    11 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. 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.

    11 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 →
  5. 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.

    11 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 →
  6. 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.

    11 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. 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.

    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 →
  8. mac client support

    Create the client side drivers required to allow macs to connect to Azure Analysis Services.

    This would then allow tableau/excel users on mac to consume analysis services.

    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 →
  9. 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…

    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 →
  10. Get visuals back after importing pbix file

    After importing a PBIX file, I have to rebuild my visuals, would be great if you could get a pbix back after importing that has the same visuals but now connected to the new AAS model.

    9 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 →
  11. Outer join relationship

    Sometimes you have a business requirement where there is a measure in a Sales Order Header fact table but then you need to join to a table of zero-to-many salespeople associated with the order. The business would like to see the sales measure repeated when there are multiple salespeople. But the business would like to show a blank salesperson (without losing the sales order header row) when there are zero salespeople associated with an order. Essentially this is a left outer join to a table.

    Certainly you can write a custom DAX query to do this with the NATURALLEFTOUTERJOIN DAX…

    9 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. Maintenance Windows on AAS

    As with other hosted services, uptime and predictability are crucial for our users. We need to have a way of knowing when the server will be brought down for maintenance so we can schedule processing around it and notify our users well in advance.

    The best way would be to implement maintenance windows, like SQL DWH, but a short-term fix could be to implement notifications BEFORE server downtime.

    Two times in the last week, our automated nightly processing has been interrupted by "Server upgrade/restart". As this is a long-running processing and it is interrupted at the tail-end of the process,…

    8 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. 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.

    8 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 →
  14. 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.

    8 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 →
  15. Azure Analysis Services model as data source itself

    Allow for having a central/master AAS tabular semantic model that is a source for some satellite AAS semantic models (import or live, the latter ideal) that are consumed in live connection mode with tools like Power BI.

    8 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 →
  16. Add ability to use Event Stream & Event File targets for xEvent Sessions

    xEvents are tremendously helpful for monitoring and troubleshooting performance issues.

    Ideally we'd get both "Event Stream" and "Event File" targets as there are good use cases for both.

    8 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 →
  17. system-assigned managed identity

    It would be nice to allow the creation of system-assigned managed identity this would unblock the ability to use AAS to authenticate directly to a data source such as Azure SQL DB without using a user-created service principal or relying on sql authentication which uses OAuth2 credentials that expire

    https://docs.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/overview

    7 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. Deploying bim file using Powershell

    Currently we are manually creating TMSL file from bim file and checking-in to invoke deployment via powershell using Invoke-AsCmd. Can we have option to deploy directly from bim file?

    7 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 →
  19. AAS Web designer - edit Model

    To be able to edit model (add new tables, fields) in AAS Web designer. Currently a new model has to be added, if any structural change takes place in Azure SQL database.

    7 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. Add a "process upon table import" option/toggle for in-memory models

    Sometimes you don't want to process a table after importing it (using the Query Editor in SSDT). Instead you only want to add the table structure and query expression to the model.bim file.
    Then if you want to later you can use SSDT's process partition/table/all button, or you can use SSMS to connect to the workspace server and process your database for a faster processing experience.

    7 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

Feedback and Knowledge Base