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. 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 →
  2. Snowflake connector for Azure Analysis Service

    Please create a connector for Snowflake in Azure Analysis Service. Having to use a on-premise gateway does not really make sense.

    56 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 →
  3. 14 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 →
  4. 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 →
  5. 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 →
  6. 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.

    3 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. Support ADLS Gen2

    Please add ADLS Gen2 as a supported data source to Azure Analysis Services.

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

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

    29 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. Enable Analysis service to access same region VNET Integrated services

    Analysis service can not pull data from azure storage account if the VNET Integration is enabled on the storage account in the same region.

    Enable VNET Integration like App Service VNET Integration preview feature as one example.

    2 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. Highly Available SSAS through syncing

    I'm trying to implement an automated fail-over solution. Read https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-bcdr but the solutions are not automated fail-overs.
    I'm wondering if using the sync feature of SSAS to sync secondary with the primary (after processing is done on primary) is a stable and feasible solution?

    1 vote
    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. Provide Process Logging

    There doesn't appear to be any way to observe a model being processed. For example if I start a model process with the asynchronous REST API, I can't find out afterwards (i.e. by logging in through SSMS) what is currently executing and what is complete. XEvents don't appear to provide me with this information either.

    1 vote
    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 →
  13. does Azure Analysis Service support Azure databricks delta table ?

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

    1 vote
    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. 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/

    1 vote
    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 →
  15. 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 .

    4 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. Excel should be able to connect to AAS without explicit login being provided in Connection String

    In the past with SSAS you could use Windows Authentication in your connection and send your excel file to other users and they could refresh

    With AAS this is not possible as you have to put your login in the connection string which is very unfriendly

    I thought this guide might help https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/analysis-services/analysis-services-odc.md and initially it does seem work for asazure:// protocol, but it doesn't work for link:// protocol which we have employed

    I posted this feedback on that page and was told to post this here.

    ------

    Please can you extend this capability to work with the link:// protocol.

    1 vote
    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. Support Display Folders for Table Objects

    Would love to see Display Folder support added for table objects. This would allow developers to logically group tables by entity\purpose\category\etc so they appear together in the object pane without resorting to forced, unnatural naming conventions or unnecessary normalization.
    Please note I am *not* talking about perspectives (which work fine for building targeted subsets of a model to support different groups of users or breaking up large, complex models into more manageable views.) Rather, display folders add a simple and visual way for the modeler to convey additional context to users about the data model and give them a much…

    40 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 →
  18. Allow user priority to boost users' execution priority

    It would be really useful to allow a user priority value, so users with higher priorities get execution priority too, and their queries will preempt lower priority requests.

    1 vote
    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. Revise down activity log entries for paused AAS instances

    When an Azure Analysis Services instance is paused, it generates two activity log 'Health Event' entries per hour.

    This needlessly populates the log and makes it a little harder to spot anything significant.

    1 vote
    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. 1 vote
    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 →
← Previous 1 3 4 5 6 7 8
  • Don't see your idea?

Azure Analysis Services

Feedback and Knowledge Base