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. Create a "metadata" model.bim template that can target a specific Analysis Services database

    Business users and report-writers that interface with the tabular model often have many questions about what the relationships between tables are, what the specific measure definitions are, or just want to know general description information about the model.

    While I can create a generic "metadata" model myself that connects to a targeted AS database's DMVs, it'd be nice if Microsoft created a standard template as a model.bim file and published it so that we can very easily edit the datasource to select our targeted model.

    6 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. Tabular model KPI status thresholds using fields

    We should be able to set the KPI status thresholds using table fields or measures. In my business KPI thresholds change with seasons and item categories. So by being able to set these thresholds using table fields or measures, the thresholds can be set without having to edit the datamodel.

    6 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. 5 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. 5 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 →
  5. 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.

    5 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 →
  6. Highly Available Azure Cubes

    I would like to see a feature in Azure analysis service where when if a server or cube is getting processed the report connection can be redirected to another server. This functionality can be done in on premise cubes with help of load balancer and shell scripts. Anything of this sort on Azure can be great full.

    5 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 →
  7. "Overdraft Protection" for Memory Consumption

    Similar to overdraft protection on a bank account... would be nice to have a similar concept for Azure AS instances where the instance auto-scales up if memory consumption exceeds the current limit (instead of an error - for example during processing)

    5 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 →
  8. Direct Query between Azure Analysis Services and Snowflake

    Currently, we are using the on-premise data gateway to connect Azure Analysis services to Snowflake.
    Instead, it would be great to have a direct query connection established between Azure Analysis services and Snowflake.

    4 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. Invoke-ASCmd for PowerShell Core

    Currently, the module SqlServer doesn't import all cmdlets when running PowerShell Core.

    I find this very confusing because there is no place in the Azure documentation that mentions this restriction. Actually, the documentation promotes the usage of the Invoke-ASCmd in multiple situations but doesn't mention that this can't be run in Azure services like Function App or App Service because they use PowerShell Core.

    The only alternative I could find is to run the same on a Virtual Machine, that's something that I didn't want to do: I have to do all the start-stop mechanisms to simulate something "serverless".

    Here's…

    4 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 →
  10. auto-restart

    Update Azure Analysis services so it auto-pauses after 1 hour of inactivity and then auto-restarts when the first person tries to access it similar to the functionality for Azure SQL Server.

    4 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. Diagram lacks functionality

    If you compare the Diagram functionality withing Tabular Analysis Services to Dimensional Analysis Services, the tabular one is too simple.
    The dimensional one has a possiblity to create "layers" or views which can reduce the complexity.

    Please make it possible that
    - You can create multiple diagrams within Tabular AS.
    - You can save those diagrams within the BIM file.
    - When you create an ASDDatbase file, it should contain those diagrams.
    - You should be able to view the diagrams in SQL Management Studio just like a SQL Database.
    - You should be able to view the diagrams when…

    4 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

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. HANA DirectQuery for Azure Analysis Services

    It's available for PBI, would be nice to have it on Azure Analysis Services as well so we can build and manage our models in a single place. Doesn't make sense to pull data from one in-memory solution to another.

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

    4 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 →
  14. Improve Whitelisting

    Currently users have to have their IP address whitelisted in order to promote or manage the model from Visual Studio. This can be difficult with remote employees as IP addresses can change and it is difficult to manually input a large amount. Ideally it would be nice if a new way could be created that is easier to manage large number of remote users. Maybe a security token of some sort?

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

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

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

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

    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

    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 …

  19. Allow Azure data factory to connect with Azure Analysis Services as Source

    Allow Azure data Bricks,Azure data Factory, SQL Server to connect with Azure Analysis Services as 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 →
  20. Ability to make a database hidden

    I would like to be able to set a specific database as Hidden like I'm able to set a table as hidden.

    The idea is to hide the development databases from the user-base.

    This is an idea, which is targeted more to the on-premise Analysis services, but it can be useful for Azure Analysis services 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 →
  • Don't see your idea?

Azure Analysis Services

Categories

Feedback and Knowledge Base