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

    No option to delete tabular Model

    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 →
  2. 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
    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 →
  3. 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
    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. 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
    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 →
  5. 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
    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. 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
    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. 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
    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. 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
    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. 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
    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. 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
    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. 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
    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. 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
    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 →
  13. Allow Updating Azure Analysis Services while in Paused state

    When an Azure Analysis Services instance is Paused, any deployment of an Azure Resource Manager Template that includes the Azure Analysis Services instance fail with the error "The server is currently being updated. Please try again later.".

    This happens even if the exact same configuration is applied to the Azure Analysis Services instance and has the potential to break CI/CD pipelines as a result.

    Azure should allow Analysis Services to be "updated" by Resource Manager Templates while in the Paused state for configuration that is not dependent upon a running instance.

    Other Azure resources like Stream Analytics and Synapse Analytics…

    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 →
  14. Firewall Rules DeployifNotExist Policy to check compliance

    We are wanting to implement a policy that will deploy firewall rules through policy to Azure Analysis Server. Every scenario I tried doesn't seem to work. It looks like the Existence condition doesn't like the alias's for this service. I could be doing something wrong, but if there is a way or could be a way to do this, that would be great. It appears within the Api there is not an Enable Option for the firewall to set to true, so wondering if that may be the problem.

    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. 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
    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. 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
    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. Importante analisar todos os serviços em descrição ao servir os usuários que comentam

    Auto analisar os serviços prestados pelos os sites Microsoft Azure e os demais.

    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 →
  18. Create connection gateway form does not recognize my on-premise data gateway

    Hi, I tried to create an on-premise data gateway on my local machine to import data into Azure Analysis Services tabular project. I followed the instructions downloading and installing the app on my computer. However, when I try to create a gateway from Azure portal, it does not recognize the installed instance. Please refer to attached screenshots.

    Could you please help on this please? I have tried using an Azure VM and did the same steps. Still failed to achieve it.

    Thank you,
    Sam

    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. Give user a choice to elect or decline alert auto-disabling query-based alert rules; they are auto-disabled on repeated query syntax error

    If we deploy a LoadBalancer resource, and a LoadBalancer alert rule via ARM template – that rule gets automatically disabled by Azure because the table doesn’t exist yet (until the probe state changes, or some other resource writes to AzureDiagnostics), causing the query in the alert rule to have a syntax error - then, when the probe state does * change due to an error condition, the alert won’t be triggered because the alert rule has been auto-disabled by Azure. Azure auto-disables alert rules when there is a query syntax error. Give the user a choice to elect * this…

    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. Cassandra Azure CosmosDB as a data source

    Is there a way to connect Cassandra Azure CosmosDB to Azure Analysis Services?

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

Azure Analysis Services

Categories

Feedback and Knowledge Base