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. Allow "With Measure" to specify a format string

    When writing an MDX query a "With Member" clause can optionally add a Format_String to the declaration.

    It would be very useful to have this option for "With Measure" DAX clauses too.

    For example a column can have a FormatString specified in the model, but there is no way to use this in an MDX query if you write
    With Measure 'Table'[Sum of Amount] = Sum('Table'[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 →
  2. xirr

    Power BI report, Azure Analysis Services XIRR function return "The XIRR function couldn't find a solution" when the investment data set loss is huge,or/and multiple rate of returns is possible.

    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. Enable OAuth2 support for Direct Query

    Enable OAuth2 Support for Direct Query. Certain organizations are locked down and cannot use SQL login etc

    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. 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. Unable to Slice from Outrigger Dimensions

    I see an issue while querying data from an Outrigger Dimension, for example DimAddress have DimState and DimZip as Foreign keys from different dimensions and when I using the above dimensions as filters, the result I see from the Outrigger Dimension in this case, Dim Address is a Cartesian product.

    Also goes for the fact tables if defined as dimension but not as a measure group would result in Cartesian product. Please let me know how to resolve this problem.

    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 →
  6. Elastic pool concept for Azure Analysis Services

    Elastic pool concept for Azure Analysis Services.

    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. 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 →
  8. 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 →
  9. Auto token refresh with MFA enabled

    Auto token refresh in AAS is still not possible with MFA enabled currently, please consider to integrate the auto token refresh feature with MFA as MFA is required to secure AAD account sign in

    2 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 →
  10. 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. 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 →
  12. Direct Query between Azure Analysis Services and Snowflake

    Currently, we are using the on-premise data gateway to connect Azure Analysis services to Snowflake.
    Instead, it would be great to have a direct query connection established between Azure Analysis services and Snowflake.

    4 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. Enable users to update table schema during a database or Table process/refresh

    At present, it is not possible to dynamically update your table schema using steps in your table definition / Power Query.

    i.e Dynamically:
    Generate a new column OR
    Set a column data type of the newly created field

    Consider a scenario where your table is created from a step that aims to dynamically generate a new column based on a transform step. See two Example transform images attached.

    It has been confirmed that there is no way to enable this Dynamically or programmatically update the table schema/defination via a Database or Table process/refresh option.
    (Process Default, Process etc.)

    https://docs.microsoft.com/en-us/answers/questions/190831/ways-to-dynamically-add-a-new-column-into-azure-an.html?childToView=197670#answer-197670

    You…

    15 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
← Previous 1 3 4 5 9 10
  • Don't see your idea?

Azure Analysis Services

Categories

Feedback and Knowledge Base