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. QPU Percent Utilisation metric for Azure Analysis Services

    There's no metric available for Azure Analysis Services to show the percent utilisation of QPU - only absolute QPU usage.

    This makes it hard to alert on because a single threshold value won't scale with the size of the instance.

    Azure SQL offers a DTU percent consumption metric which is a function of usage/DTU limit of the instance.

    Is there a good reason the equivalent can't be added for AAS?

    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. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. No way to chart duration in Log Analytics?!!

    Perhaps I am doing something wrong but in Log Analytics there is a Duration_s column that provides the length of time of a query_end 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 →
  13. 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 →
  14. 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 →
  15. Respect data types when AAS model is being viewed in Excel

    We have found that when viewing a cube pivot based on AAS that all data values are imported as string, regardless of the type set in the model.
    This is in spite of the fact that when viewing standard Tabular Analysis Services models in Excel data types are respected.
    Recognising data types allows for the creation of date hierarchies and mitigates sorting issues that occur when sorting by text values.
    Please import data into the correct types when an AAS model is being viewed in Excel.

    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. Copy and Past option to simply copy a table from diagram view

    There is no copy and past option in Diagram /Grid view to copy and paste the table. Sometimes reporting team requires same copy of existing table for achieving the functionality of Chart As. In this case copy and past is very useful

    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. Parse out Admin Rights on SSAS for Deployments

    My company has strict security requirements and without a clear way to isolate the ability for a developer to easily and with agility deploy their SSAS solutions to either the Development Server or Production Server we will be unable to use SSAS Tabular as our strategic data modeling/semantic tool going forward. The easiest solution for us would be to parse out the Admin Permissions or allow for a Custom Role to allow a development team to deploy to a shared SSAS Server (shared amongst different application teams from different lines of business where data isolation is imperative) in (Dev or…

    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. Have server names change when connection changes

    It would be useful if it were possible to change the server name in Analysis Services by changing the connection for the cube.

    It's inconvenient that we have to recreate the server to change the name.

    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. Create 'Export To Text' button when viewing the Model in Script Mode

    Right now when you view the model as a script if you copy and paste this to use it will be decorated with "" so it's not valid JSON.

    Would be better to have an export button so we can easily use the script.

    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. blanks excel

    Fix or at least provide an option to suppress showing of blanks where there are no blanks in the relevant table column in client tools (Pivot Table, Power BI)

    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