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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. Allow support to add a Private Endpoint/Link to the Azure Analysis Services

    If the feature to add a Private Endpoint/Link to the AAS would be added. Then the whitelisting on the AAS firewall can be exchanged for the use of a P2S VPN. This way everyone can make a Private connection with the SSAS while they are working from the SSMS. This would also make it a ton easier to manage and of course more secured.

    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. 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. 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 →
  8. 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 →
  9. 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 →
  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

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. Invoke-ASCmd for PowerShell Core

    Currently, the module SqlServer doesn't import all cmdlets when running PowerShell Core.

    I find this very confusing because there is no place in the Azure documentation that mentions this restriction. Actually, the documentation promotes the usage of the Invoke-ASCmd in multiple situations but doesn't mention that this can't be run in Azure services like Function App or App Service because they use PowerShell Core.

    The only alternative I could find is to run the same on a Virtual Machine, that's something that I didn't want to do: I have to do all the start-stop mechanisms to simulate something "serverless".

    Here's…

    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

    1 comment  ·  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