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. 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 →
  2. 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 →
  3. 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. 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 →
  5. 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 →
  6. 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 →
  7. parquet fle data source

    add support to parquet file as a data source

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

    6 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. HANA DirectQuery for Azure Analysis Services

    It's available for PBI, would be nice to have it on Azure Analysis Services as well so we can build and manage our models in a single place. Doesn't make sense to pull data from one in-memory solution to another.

    4 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 →
  14. 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 →
  15. 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 →
  16. Option to allow all Azure services through the firewall

    Azure Analysis Services has a firewall option since 2017. However, there is only a tick box to allow Power BI to access it. For every other Azure service, you manually need to add the IP address ranges of the specific datacenter region to the firewall. This is manual labor, prone to errors and not like some other services such as SQL server, Storage Accounts and Key Vault which do provide an easy tick box to allow all Azure services.

    9 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. Allow GUI support to change between M and SQL query type in SSDT

    Working on existing compatibility level 1200 model project migrating to compatibility level 1400 model project require user to edit or re-create data sources and changing partitions from query type SQL to M language manually. It will be great to have an option to change existing query type from M language to SQL and vice versa in the designer view.

    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 →
  18. Key Vault for Connection string using secrets

    The Key Vault implementation is widely accepted for security reasons and greatly simplifies the work of rotating / change passwords using secrets. When you have a big number of models this becomes a tedious job if you have hundred of models on top of a data warehouse.

    The super awesomeness would be to be able to configure and entire connection from the secrets. When changing environments (Dev to QA or QA to Prod) would just take changing Key Vaults.

    6 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. Highly Available SSAS through syncing

    I'm trying to implement an automated fail-over solution. Read https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-bcdr but the solutions are not automated fail-overs.
    I'm wondering if using the sync feature of SSAS to sync secondary with the primary (after processing is done on primary) is a stable and feasible solution?

    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. Maintenance Windows on AAS

    As with other hosted services, uptime and predictability are crucial for our users. We need to have a way of knowing when the server will be brought down for maintenance so we can schedule processing around it and notify our users well in advance.

    The best way would be to implement maintenance windows, like SQL DWH, but a short-term fix could be to implement notifications BEFORE server downtime.

    Two times in the last week, our automated nightly processing has been interrupted by "Server upgrade/restart". As this is a long-running processing and it is interrupted at the tail-end of the process,…

    20 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  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