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. 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 →
  2. Straight Numeric Presentations

    The demo on NYC Taxi Fares and Pickups was very nice, Mechanics. The graphical visualizations are totally sick! Still, I crave the golden days when the Pivot Table was truly multidimensional, just like in some of the earlier BIDS Browsers and Excel Services. Now its seems everything is flattened out - too bad. The Tabular Model and Power BI are cool, but it seems to me that "true" multi-dimensional grids with nicely aligned "dynamic stacking boundary lines" and cascading hierarchies provided a more interesting navigation and allowed drag-drop operations with instant dollar figures coming down the pipe to the display.…

    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 →
  3. 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 →
  4. Improve the error logging when Visual Studio crashes

    It's not always easy to re-produce a crash in SSDT, and at times it can feel like the crash was due to typing out a measure too quickly, coming up with wacky m queries, or perhaps even because it is too windy outside. An improved error log would at least give me some solace that SSDT isn't prejudicing my model development due to my taste in music.

    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 →
  5. Support for non-native applications

    Support for non-native applications. ie. Support for Java app using Analysis Service PaaS. REST or JDBC support

    4 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 →

    Thanks for the update. I’m assuming you are talking specifically about URL access in such a way that works for 3rd party libraries such as OLAP4J and also general URL access without limitations around auth and resolving cluster IP addresses, etc.. We will look into it …

  6. Databricks

    AAS should be able to connect to the Databricks ODBC server, just like it can connect to HDInsight and just like PowerBI can connect to the Databricks ODBC server.

    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. Support ADLS Gen2

    Please add ADLS Gen2 as a supported data source to Azure Analysis Services.

    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 →
  8. 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 →
  9. Column and measure security

    To me, the BIGGEST drawback of SSAS-TAB/AAS is the lack of security around columns and measures. In many cases, we need to give access to certain users to only part of the model. I.e: some users can see only sales, while others can see net margins (including costs).

    Today, the only way to do this is to duplicate the model and drop columns or measure, which adds overhead in time and cost.

    Maybe, if users could be locked to a perspective (and prevented from using freeform DAX), this could be accomplished ? Or something like that.

    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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. Enable Analysis service to access same region VNET Integrated services

    Analysis service can not pull data from azure storage account if the VNET Integration is enabled on the storage account in the same region.

    Enable VNET Integration like App Service VNET Integration preview feature as one example.

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

    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. 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 →
  19. 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. Allow connection to each replica

    Scenario 1: I need to check whether any queries are running on any replicas before I pause the Azure Analysis Services instance.

    Scenario 2: I need to find and cancel any queries which have been running for more than 5 minutes and I can't control the Timeout connection string property in the client tool such as in Power BI.

    I would like to have some new syntax which lets me connect to each query replica with the following server name:
    asazure://southcentralus.asazure.windows.net/servername:ro1
    asazure://southcentralus.asazure.windows.net/servername:ro2

    The :ro1 and :ro2 syntax would let me connect to query replica 1 and 2.

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

Azure Analysis Services

Feedback and Knowledge Base