Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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. parquet fle data source

    add support to parquet file as a data source

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Allow Security Group to be added as Analysis Admin

    Currently this supports only Distribution group but as a workaround the security group can be added through the SSMS tool using the objectId. We should be able to do this from the Azure Portal as well.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. CubeDimension.HierarchyUniqueNameStyle

    We have following scenario:
    In Multidimension:
    Dimension 1: ReceivedDate
    Hiearchy: FiscalYearWeek
    Year, Week
    Dimension 2: DisDate
    Hiearchy: FiscalYearWeek
    Year, Week
    When we pull the hierarchy in Rows in Excel or Power BI we see the name as
    ReceivedDate - FiscalYearWeek
    DisDate - FiscalYearWeek
    This was due to property - CubeDimension.HierarchyUniqueNameStyle

    In Tabular:
    Table 1: ReceivedDate
    Hiearchy: FiscalYearWeek
    Year, Week
    Table 2: DisDate
    Hiearchy: FiscalYearWeek
    Year, Week

    When we pull the hierarchy in Rows in Excel or Power BI we see the name as
    FiscalYearWeek
    FiscalYearWeek

    It creates probem for users that they do not understand the hierarchy that is is…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow programmatic import of PBIX to Azure Analysis

    Just that, import via web interface is great but only once. To allow modeling to continue in PowerBI Desktop, it'd be sweet to have a powershell method to import that file.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Emulation or support for member properties in Excel

    Tabular models do not support the Properties function in Excel. (right click on a member, select properties, you get a blank list). This is because Tabular models do not have member properties as far as I know. However, users of legacy multi-dimensional cubes may have been trained to use properties in Excel and may be confused as to why this option doesn't work with newer tabular models.

    I would like to suggest that Analysis Services either provide the functionality for member properties for designers of tabular models OR provide some kind of emulation in Excel so the end user has…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. HIPAA compliance for Azure Analysis service

    AS per the below link,

    https://www.microsoft.com/en-us/trustcenter/compliance/hipaa

    Azure analysis service is not under the covered services for HIPAA compliance, So please include the support else we have to use only SQL Server inside an Azure VM instead of going with AAS.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Basic filter improvement

    Query section -> filters -> Basic
    What is now, the basic filter provides including different rows of 1 column, implemented as a simple select(dropdown menu). But if I need to select a big number of rows at once, I have to search select each of them so many times. To my mind, it is better to customize the choice, because it may be sometimes disgusting to pick every.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Syntax highlighting for TMSL

    Can we get syntax highlighting for TMSL? Maybe even intellisense? It'd be really handy when editing a model.bim file.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Encode as integer

    My data lineage systems frequently use uniqueidentifiers or hash keys. I have to apply surrogate keys to them which doesn't parallelise well or compress well in the vertipak engine.

    I would like to import these fields directly into the analysis services model and mark them "encode as integer". Analysis services should encode and display the columns as an integer. The alpha-numeric code should not be stored in the dictionary. At process time, the original values would be read, coalesced across active and inactive dax relationships (thus part might be tricky) , compiled and then discarded.

    My nderstanding is that it…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  11. Improve connection experience

    This is driving me a bit nuts.
    I have two machines. One local and a Azure VM with:
    SQL Server 2016
    SSAS Tabular
    and
    Azure SQL database.

    My employer doesn't have any Azure Active directory services.

    I've created an AAS server and can connect to it with ssms.

    When I try to deploy I get error messages, but somehow the metadata for both database sources has been deployed but it cant process.

    It keeps insisting that the impersonation settings are invalid but I can only use windows authentication to access the vm in azure.

    At first I forgot to add…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  12. Auto token refresh with MFA enabled

    Auto token refresh in AAS is still not possible with MFA enabled currently, please consider to integrate the auto token refresh feature with MFA as MFA is required to secure AAD account sign in

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    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…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    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.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow user priority to boost users' execution priority

    It would be really useful to allow a user priority value, so users with higher priorities get execution priority too, and their queries will preempt lower priority requests.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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?

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    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