Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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

    Support Custom ODBC Drivers for importing data
    (ex: Apache Drill, Hive, PostGres etc)

    35 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →

    We are definitely looking at how to provide more access to such data sources. Not sure on technical specifics at this stage, but is a priority and you should hear more about this in the not too distant future :)

  2. Direct Query Mode to Exasol database

    The user community for Exasol's analytic database is rapidly growing. As of now it is possible to access on premise Exasol databases in direct query mode from Power BI. However, direct query access from Azure Analysis Services is not yet possible. For all companies that run an Exasol BI database it is absolutely necessary to have direct query mode through AAS - rather than through Power BI.

    34 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. private endpoints

    Add option to enable Private Link/private Endpoints for Analysis Services. vNET integration, similar to how many other Azure resources can integrate with Private IP addresses and DNS, would help many teams to simplify designs for connecting to other services such as SQL DB/Synapse.

    32 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. AAS support service principal authentication to access data from Azure Data Lake Store

    AAS support service principal authentication to access data from Azure Data Lake Store.

    Currently it uses OAuth which has limited token time (2 hours) and expires after that - which is not ideal for production work load.

    32 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Auto scaling option based on QPUs in Azure AS server as an inbuilt option in the portal

    Based on the QPU limit of Azure AAS for an tier, it will be a great idea to have an auto scale option(which can be set to optional) to move to next tier or to downgrade to the appropriate tier based on QPUs. This option will save the significant cost and help for better performance. It will be great if it allows the user to set the threshold and number of times to check for the particular metric to move to the next tier.

    31 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Elastic SSAS pools, similar to Elastic database pools

    Pool of SSAS dbs for managing the collective performance of SSAS cubes and reducing costs. Much like Azure SQL db's elastic database pool feature.

    29 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. does Azure Analysis Service support Azure databricks delta table ?

    does Azure Analysis Service supports Azure databricks delta table ? If yes How does it ?

    28 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Direct connectivity support from Azure Analysis Services to Azure Tables

    Currently using Azure Tables as a data source from within Azure Analysis Services requires a gateway. This makes a serverless architecture impossible forcing the need to run a VM simply to host a gateway. Please provide direct connectivity between these Azure services so a gateway isn't required.

    27 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Provide Geo-Redundancy

    Provide Geo-Redundancy features along the lines of the DR/scale out functionality available for Azure SQL databases

    27 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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.

    26 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

    26 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Multiple relations for datehierarchy in tabularmodel

    we have several fact-tables which refer with different date-columns to a datehierachy. At the moment we need to implement for each date-column a separete date-table (including the Datehierarchy). This makes to model large and confusing.

    Improvment: similar to multidimensional-cubes we want to implent just one datehierarchy which can refer to many date-column in several fact-tables. (at the moment we can just refer one active relation to another table)

    23 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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,…

    22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. sync

    Ability to synchronize databases between Azure SSAS and on-prem SSAS.

    22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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.

    22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Dynamic Format String based on DAX Expression

    Allow the Format String property for a measure to be determined by the results of a DAX Expression.

    This would be similar to the approach in the below link. However, instead of using the FORMAT() function within the measure's DAX expression, the format should be able to dynamically be set using the Format String property of the measure.

    https://christianwade.wordpress.com/2012/08/21/currency-conversion-formatting-symbols-in-tabular/

    20 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  17. Allow to use SOAP and XML/A over a direct HTTP connection to AAS, like MSMDPUMP.DLL

    Allow to use SOAP and XML/A over a direct HTTP connection to AAS, like MSMDPUMP.DLL

    20 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Make Microsoft Azure Analysis Services availible for non default AAD users

    It would be nice to be able to be able to grant access to users that are not part of the Default AAD. It could be users from a Customers AAD directories that are not your subscription or/and from users that are in another Directory in the subscription

    20 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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.

    19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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.

    17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Azure Analysis Services

Categories

Feedback and Knowledge Base