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. Embed RLS Power Bi reports with Analysis Service data (live connection)

    The ability to embed Power BI reports from a live Analysis Service data connection and use row-level security to control what data a user can access in a "app owns data" scenario.

    For more details, see: http://community.powerbi.com/t5/Service/Azure-Analysis-Services-RLS-and-Embedding/td-p/239127/highlight/false

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

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Conditional formatting support in Tabular

    Please add support for conditional formatting for measures (e.g. http://richardlees.blogspot.com/2008/11/elaborate-your-cubes-with-conditional.html). Some customers have invested in this and is an adoption blocker for tabular.

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

    23 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 →
  5. firewall

    At the moment it does not look like it is possible to lock down access to the analysis services public endpoint by IP address. It would be good to have a firewall in a similar way to SQL Azure or Azure Data Warehouse.

    23 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 →
  6. Provide Geo-Redundancy

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

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

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

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

    22 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 →
  9. Return refreshID in the API response to GET /refreshes/<refreshID>

    When I call the POST /refreshes API in order to initiate an asynchronous refresh operation it redirects me to GET /refreshes/<refreshID> and the only way to know what refreshID I just initiated is by parsing the Location header or redirected URL. This is very non-standard. It's also not possible to accomplish this with a Web Activity in ADFv2.

    Please change the GET /refreshes/<refreshID> API to return the refreshID as a property inside the JSON response. That's a very easy change and would be tremendously helpful.

    This is the API I'm talking about:
    https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-async-refresh#get-refreshesrefreshid

    21 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 →
  10. 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.

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

    We’ll send you updates on this idea

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

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

    18 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 →
  13. 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.

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

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

    We’ll send you updates on this idea

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

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

    15 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 →
  17. 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 →
  18. 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 →
  19. 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

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

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

  • Don't see your idea?

Azure Analysis Services

Feedback and Knowledge Base