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. private endpoints

    Add option to enable Private Link/private Endpoints for Analysis Services. vNET integration, similar to how many other Azure resources can integrate with Private IP addresses and DNS, would help many teams to simplify designs for connecting to other services such as SQL DB/Synapse.

    2 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 →
  2. private endpoints

    Add option to enable Private Link/private Endpoints for Analysis Services. vNET integration, similar to how many other Azure resources can integrate with Private IP addresses and DNS, would help many teams to simplify designs for connecting to other services such as SQL DB/Synapse.

    0 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 →
  3. Allow Azure data factory to connect with Azure Analysis Services as Source

    Allow Azure data Bricks,Azure data Factory, SQL Server to connect with Azure Analysis Services as Source

    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. auto-restart

    Update Azure Analysis services so it auto-pauses after 1 hour of inactivity and then auto-restarts when the first person tries to access it similar to the functionality for Azure SQL Server.

    3 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 →
  5. 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 →
  6. Ability to make a database hidden

    I would like to be able to set a specific database as Hidden like I'm able to set a table as hidden.

    The idea is to hide the development databases from the user-base.

    This is an idea, which is targeted more to the on-premise Analysis services, but it can be useful for Azure Analysis services as well.

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

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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 →
  11. 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 →
  12. 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 →
  13. Diagram lacks functionality

    If you compare the Diagram functionality withing Tabular Analysis Services to Dimensional Analysis Services, the tabular one is too simple.
    The dimensional one has a possiblity to create "layers" or views which can reduce the complexity.

    Please make it possible that
    - You can create multiple diagrams within Tabular AS.
    - You can save those diagrams within the BIM file.
    - When you create an ASDDatbase file, it should contain those diagrams.
    - You should be able to view the diagrams in SQL Management Studio just like a SQL Database.
    - You should be able to view the diagrams when…

    4 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 →
  14. 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 →
  15. parquet fle data source

    add support to parquet file as a data source

    3 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. Process Azure Analysis Services Tabular Model from Data Factory

    This idea consist in being able to process an Analysis Services Model from Data Factory.
    Ideally using the Data Factory Managed Identity.

    8 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 →
  17. 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 →
  18. in results to grid in SSMS, maintain CR/LF

    In the results of a DAX query against a AAS cube, the results don't maintain line breaks or other formatting.

    2 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 →
  19. BUG : datediff gives an error when startdate is bigger then enddate

    Clearly stated in the documentation https://docs.microsoft.com/en-us/dax/datediff-function-dax but in other systems (Excel/SQL) it should return negative values

    2 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 →
  20. Post when updates are pushed out to AAS

    Please post somewhere on the Azure Portal when updates are pushed out to AAS. In early December, two of our models were no longer able to process due to invalid, but unused, M query code. Removing the code allowed us to refresh the models.

    As there is no posting of when updates are posted, we can only assume that an update was pushed to AAS that prevented our models from refreshing. If there was a posting that we could reference, it would help us with identifying the issue and building a workaround for it sooner.

    2 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 →
← Previous 1 3 4 5 8 9
  • Don't see your idea?

Azure Analysis Services

Categories

Feedback and Knowledge Base