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. 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
    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. 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 →
  3. 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
    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 →
  4. 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
    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. 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
    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. 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
    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. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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
    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 →
  9. 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
    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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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
    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. 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
    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. Azure Portal Metrics AAS - split by database

    Would be great to be able to use database as a splitting variable when analyzing metrics in the portal for AAS. For example, I am interested to know the memory consumption of each DB on the server, but that can only be achieved right now through DMVs.

    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. Open Source Web Designer (Now Deprecated)?

    Even though I knew it was slated for deprecation, I was still sad seeing the web designer go. It was a really well done piece of software. Yeah, the pbix import was a nice to have but tbh what blew me away was its usefulness as querying / exploration tool. The interface was top notch supporting both casual browsing via drag and drop as well as the query editor for more advanced authoring. Any chance we could see the tool (or snippets of it) open sourced? : )

    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. RetainPartitions

    Need an option to use the RetainPartitions from MD on Tabular as manually adding partitions instead for having and automated process is not ideal.

    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. Client libraries for JavaScript/TypeScript clients

    Currently, there are no officially supported client libraries available for NodeJS clients built using JS/TypeScript languages. The only way to access data from tabular models/cubes is to use another wrapper C# service and talk to that service from the NodeJS client (see this forum post for context: https://social.msdn.microsoft.com/Forums/en-US/cb5c7edb-5eeb-41dd-b59b-f40253bf5e69/nodejstypescript-client-library-support-of-azure-as?forum=AzureAnalysisServices)

    It would be great to have an official library package for these kinds of clients.

    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 →
  • Don't see your idea?

Azure Analysis Services

Categories

Feedback and Knowledge Base