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. Easy data masking

    We would to have the ability to mask data of a specific column depending on the user role.

    At the moment it is possible to hide a specific column by creating a new role. This option has some idiosyncrasies, because when you have a column that appears on a PowerBI report, the reports crashes for users with this specific role. This because the column is hidden.

    1 vote

    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 →
  2. Upgrade from S4 to S8 v2 , will query replicas remain same ?

    I have upgraded my AAS server in East US 2 from S4 with 2 query replicas to S8 v2 . The query replica are still showing 2 after upgrade . But, as per https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview , max replicas allowed for S8 v2 in East US 2 is only 1. Is it an issue with azure portal or the no. of replicas created remain intact after upgrade ?

    1 vote

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

    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 →
  4. Extend Security to Perspectives

    Extending the Security model to perspectives would enable Adminstrators to better control the user experience and eliminate confusion with complex data models.

    Ex. 3 Perspectives - National, East and West

      3 Roles - National , East and West
    
    3 Users - National Bob, NY Eddie and California Joe

    Each Perspective has is has only 1 role associated. National Bob is member of all 3 Roles. NY Eddie = East, California Job = West.

    National Bob can attach to all 3 perspectives and the Geography dimenstion is limited to the values specified by Role associated with that Perspective.

    NY Eddie and…

    1 vote

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

    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 →
  6. Add created Date and Time field to $SYSTEM.TMSCHEMA_MEASURES

    Hi, I would like to apologies for posting a non AAS idea on this. My request is for SSAS and I wasn't sure of the right place to post it.

    I would like to have a new field added to the view $SYSTEM.TMSCHEMA_MEASURES. Currently we only have ModifiedTime but we would like to see create date and time as well for measures for tracking purposes.

    Appreciate if you can take a look into this.

    1 vote

    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 →
  7. No option to delete tabular Model

    No option to delete tabular Model

    1 vote

    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 →
  8. Service Fabric update should happen during the weekend on Azure Analysis Servers

    Service Fabric update should happen during the weekend on Azure Analysis Servers so no any customer and stack holder face any issue during the business hours or during the model refresh processing.

    1 vote

    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 →
  9. Advance notification for Service Fabric update on Azure Analysis Services

    There should be advanced notification of service fabric update that happens on Azure Analysis Servers coz it happens at random time without intimation which affects refresh of model and lead to escalation from the stack holders which overall impact the end users.

    1 vote

    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 →
  10. Each Model Size from Azure Analysis Server

    Requesting you to have direct approach of checking size of each model into analysis server.

    There is powershell script available to check but that shows wrong size of model and whenever we ask MS to provide size of each model then they give us in tabular format.

    Same way we need to have a report so every time we don't need to approach MS to collect the data for us.

    1 vote

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

    Please provide periodic general release notes for Azure Analysis Service - defect fixes and improvement. This will help deployment, planning and migration.

    1 vote

    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. Restrict Power BI users to build new content using the underlying AAS datasets

    When dataset is published in Power BI Services there is options to give or restrict access to underlying dataset for a given AD group of report users (by adding/removing 'build' permission to dataset).

    But there is no such options in case Power BI report is live connected to AAS model. We should always allow.

    Would be good to have.
    Then there is no need to implement super sophisticated Row Level Security to restrict access to data that is not needed for given AD user group which is interested only to see some simple report.

    thanks,

    1 vote

    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. Needed Allow Azure services and resources to access this server in Azure Analysis Services

    Needed Allow Azure services and resources to access this server in Azure Analysis Services

    We need this feature for security reason. Because without this feature azure analysis server is open on internet and if we enable firewall so we have other Azure services which connects analysis server which are not getting connected without this feature.

    Please provide.

    1 vote

    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 →
  14. Access Azure Analaysis Services from PHP

    I want to be able to query Azure Analysis Services from PHP app. Is there any library that allows establishing a connection to Azure AS from PHP?

    1 vote

    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. DAX Script Editor for measures (similar to the MDX Script in Multidimensional)

    Adding measures one-at-a-time to the DAX measure grid and then configuring the measure formatting using the GUI is a slow and tedious process. In Multidimensional, it was possible to add MDX measures in bulk using a simple text editor. The definition of the MDX measure and the measure formatting were defined in a simple block of code. A DAX Script editor in Visual Studio SSDT would greatly help.

    1 vote

    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 →
  16. Include Power Bi Premium Paginated Reports on Azure Analysis Services firewall options

    Azure Analysis services "Allow access from the Power BI Service" (enablePowerBIService: true) firewall option does not include connexions initiated from Power Bi Premium Paginated Reports. The only workaround is to allow regions IP ranges from the list : https://www.microsoft.com/en-us/download/details.aspx?id=56519

    A Premium service should include such feature :

    - adding hundreds IPs to an AAS engine is a lenghty operation particularly when you have many engines to manage
    
    - custom tracking has to be done to ensure having the latest list, with automated deployment keep engines accessible
    - allowing hundreds of IPs when just 2 at a time is not the
    1 vote

    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 →
  17. Being able to disable Row Level Security per relation

    Current Row Level Security(RLS) works that when you filter on a dimension, the related fact tables get filtered. While this is a good features, sometimes you have to deal with more complex variants.

    Example: Lets say I have 2 dimensions, product and customers, and 1 fact table, sales.

    Every user is allowed to see all rows that is connected through the product or customer dimension. However, when they are looking only at the dimensions, they should only see their own products and customer.

    Both can be solved, but not in the same scenario.

    Scenario 1: See rows either attached to…

    1 vote

    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 →
  18. Calculation Groups/Types

    this is a general suggestion to the DAX/Analysis Services. Based on what I thought calculation groups would bring.

    I thought selectedmeasure() would work like, Isfiltered().. so you could somehow choose a calculation and then apply a measure in power bi.

    So i would make a YTD Calculation "group".. and then I could choose any measure in power bi and apply it to. So you don't have to create Sales YTD, Quantity YTD, OrderIntake YTD etc etc etc.

    you would simply have a "group" function called YTD. and then it could function with all the measures. to reduce the insane amount…

    1 vote

    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 →
  19. Allow backup and restore of AAS "server" settings.

    Allow restore of AAS "server" settings. Currently we can capture the settings using XMLA query, but there is no method to restore those settings to another AAS server (e.g. for DR or HA purposes).

    1 vote

    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. Support parameter validation for AAS REST API

    Currently I get a 500 error if I send a mal-formed JSON payload, this should be a 400 error with a meaningful message

    {'error':{'code':'InternalError','subCode':0,'message':'An internal error occurred.','timeStamp':'2020-03-06T10:50:57.1721115Z','httpStatusCode':500,'details':[{'code':'RootActivityId','message':'ce5ce935-2702-4023-b2f1-69abcc1a0c34'},{'code':'Param1','message':'Object reference not set to an instance of an object.'}]}}

    1 vote

    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 →
  • Don't see your idea?

Azure Analysis Services

Categories

Feedback and Knowledge Base