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. 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 →
  2. 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 →
  3. 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 →
  4. Excel should be able to connect to AAS without explicit login being provided in Connection String

    In the past with SSAS you could use Windows Authentication in your connection and send your excel file to other users and they could refresh

    With AAS this is not possible as you have to put your login in the connection string which is very unfriendly

    I thought this guide might help https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/analysis-services/analysis-services-odc.md and initially it does seem work for asazure:// protocol, but it doesn't work for link:// protocol which we have employed

    I posted this feedback on that page and was told to post this here.


    Please can you extend this capability to work with the link:// protocol.

    Right…

    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. Revise down activity log entries for paused AAS instances

    When an Azure Analysis Services instance is paused, it generates two activity log 'Health Event' entries per hour.

    This needlessly populates the log and makes it a little harder to spot anything significant.

    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. 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. Provide Process Logging

    There doesn't appear to be any way to observe a model being processed. For example if I start a model process with the asynchronous REST API, I can't find out afterwards (i.e. by logging in through SSMS) what is currently executing and what is complete. XEvents don't appear to provide me with this information either.

    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 →
  8. XMLA For Azure Analysis Services

    I'd like to see XMLA support for Azure Analysis Services the same way there is for Power BI.

    If I have a Azure Analysis Server/Datbase I should be able to query it via XMLA

    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 Azure B2B (guest) accounts to install the AS on-prem data gateway

    Right now you need to have an account in the same AD as the azure AS subscription tenant in order to be able to use your gateway for AS, which isn't convenient as you would need a separate account for every customer, which defeats the whole purpose of having 1 singe guest account to use.

    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. Dax Query

    Store Tabular Model "Views" that Users can see similar to tables. I have developers who write custom dax queries. These queries rely on the security model to the right information to each end user. This is like an advanced calculated table that does not execute until the query is sent. Currently, calculated tables calculate during model processing meaning user specific scope is not available. This would be similar to views in traditional SQL databases but just be predefined dax saved to the model definition.

    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. To provide the information regarding how to customise the upload time in Azure Analysis Services

    To provide the information regarding how to customise the upload time in Azure Analysis Services. It seems the default upload time is set to around 4 min. What if we need to upload bigger files?

    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. Add more data connectors to AAS web designer

    The AAS web designer preview is out for almost 2 years, yet it still supports only 3 data sources when creating a new data model. This is unusable in most scenarios. This is especially ridiculous when there is Power Query built-in already in AAS. As a starter, a simple data connectors like "Common Data Service", "Power BI Dataflows" or "M Script" would be sufficient for getting past that weird limitation.

    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. Spark Connector in Azure Analysis Services isn't working

    Spark Connector for Azure Analysis Services doesn't seem to be working. I attempted different connstr including the one used successfully in Power BI. Nothing seems to work. No documentation either.

    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 →
  14. link protocol doesn't work correctly with power bi and dual factor auth

    we have setup aas with a link protocol and all users have dual factor authentication as per https://community.powerbi.com/t5/Issues/Azure-Analysis-Service-live-connection-issue-with-a-pbit/idi-p/550868 .

    In powerBI if you use the link:// protocol to connect you have to go through the dual factor twice on a pbix and on a pbit (template) when you reopen it it throws up 12 dual factor auth boxes and will return an error. Not sure if the problem is power bi or whether it is the client libs but raising here. Using Oct 2018 PBID and 15.0.2.39 client library.

    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. memorize dax query after having switched to model panel

    currently if you write a query in DAX, and you run it, you can see the result
    BUT if you switch to the MODEL view, and then go back to the DAX query tab, everything shown previously is reset (it would be great to keep it). it's like if when you go back to that interface you are actually refreshing the page

    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. query tables of the model in t-sql

    possibility of querying tables of the model in t-sql besides dax

    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. save queries like in log analytics or app insights

    Once Ia DAX query has been written (or generated) it would be nice to have a SAVE QUERY, so that for testing data within the model it's easier to rerun

    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. No way to chart duration in Log Analytics?!!

    Perhaps I am doing something wrong but in Log Analytics there is a Durations column that provides the length of time of a queryend event but as it is a string (_s) it is not available to be added to the x axis.

    This seems like a pretty basic requirement of Log Analytics to chart duration. Why was duration created as a string when surely it is really numeric?

    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. link protocol should support on prem SSAS

    https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-server-alias indicates that the link:// protocol can only be used with Azure Analysis Services but this (combined with the fact that we can't automate the changing of connection strings in PowerBI.com means that a migration from onprem to PAS is a one-way operation which makes the change boards very uncomfortable.

    Please allow this to point to both onprem and PAS SSAS instances

    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. Load balancing and/or Failover On-Premises SSAS and Azure Analysis Services

    Access to Azure SSAS servers can be aliased using link:// in Power BI Desktop, thus allowing admins to load balance with Traffic manager and move models without redeployment. However this approach does not work with with on-premise SSAS servers since they do not present an https endpoint by default and is accessed by the cloud service via the Azure Gateway. Could you please provide an option for load bursting or even just failover from on-prem to Azure?

    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