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. Get-ASDatabase Powershell command

    How about adding a Powershell command to get the databases (models) within a server? We are making multiple models with an Azure AS server and are now processing them by using command Invoke-ProcessASDatabase. If we can do a Get-ASDatabase, we can loop through all the models that need to processed and start processing.
    Tags for models will also be a useful feature, for example to be able to tag the models and add processing schema (hourly, daily, etc.).

    7 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 →
  2. Azure Kusto data source

    Support Azure Kusto storage as data source, utilize Azure AS as semantics and caching engine, and use Kusto for query execution.

    6 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. Failover for Analysis Service

    Recently we faced an issue with AAS being down for around 4 hours which impacted the production server and many users were unable to do their work.

    Our solution to mitigate was create a new AAS instance in another region and restore the backup.

    Just like Azure SQL, it would be really useful to have failover solution to AAS, so in cases like that we could just automatically start the offline/secondary instance with lower down time.

    6 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 →
  4. Scale-Out Azure AS instance using PowerShell

    Allow scaling out an Azure AS instance using PowerShell script or REST APIs. Currently, the only way to scale-out is to use the Azure Portal and users may not always have an access to the Portal (specially in a Production environment). Having the ability to scale-out with PowerShell will help in automating the cube refresh process while having the users query the same AS instance simultaneously. Not to mention the added benefits to programatically scale-out during high usage periods.

    6 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. Deploying Tabular Model without disturbing existing roles

    Need ability to deploy tabular model without disturbing existing roles and its members. Currently, the only option is to fetch roles, parse the TMSL file which is complex.

    6 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 →
  6. Deploying bim file using Powershell

    Currently we are manually creating TMSL file from bim file and checking-in to invoke deployment via powershell using Invoke-AsCmd. Can we have option to deploy directly from bim file?

    6 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. M custom data source

    The AS Team have done an amazing job with Azure and 2017. However there is no support for custom data sources, which is sorely missing.

    There are so many use cases (mine is below) for this and such a feature would finally enable Excel, Power BI and Tabular to use common code for data sources. This would mean less testing and more robust solutions.

    The use case that I have, is to create an M data source that would let me connect to http endpoints, where the endpoint could return data in any format. For example csv, json, xml or…

    6 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 →
  8. In SSDT allow us to review the tables brought in by an M query

    If you decide to change your M query for a table, with the typical case being that you needed to add an additional column, you currently have to edit the model.bim file to add the new column into your actual table object.

    This new feature would allow us to see what columns get surfaced by the M query and select which ones we want imported into the model (which would typically be all of them, because otherwise you would have excluded the column in your m query).

    6 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. Allow to change the service account

    As a best practice, we'd typically use Windows auth for on-prem SSAS where the SSAS service account is granted access to the data source to process the model. Allow us to change the Azure AS service account to be used when processing from SQL Server.

    6 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. 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
    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. 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
    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. 5 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. Support for SSAS row level filters and column level security combined in the same model

    Currently SSAS 2017 security roles supports either row level filters or column level visibility only at a time. Both type of security at the same role is not supported now.

    Also currently in SSAS the same user cannot be in roles that has row level security in one role, and column level access in another role. Please see the link below for the limitation:
    https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/object-level-security?view=sql-server-2017

    However, there are requirements where users needs to be restricted by row level and column level both at the same time. SSAS should support this.

    5 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 →
  14. Additional configurations/tiers with different Memory / QPUS ratios

    Are additional configurations planned different ratios QPUS/RAM? We are often times hitting the memory limit but are no way near the QPUS limits. Also what are the plans if our model will not fit an S9 instances?
    We would be looking for an S4 with 800GB ram or S5/6 if available with 1,5TB

    5 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. 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
    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 →
  16. "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
    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 →
  17. How to perform Load testing on Azure Analysis Services

    A load testing where a same query would be fired on AAS tabular model concurrently which would the give us the metric of query execution time and AAS support load count.
    This testing need to be performed. Any guidance on this.

    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 →
  18. Use Analysis Service in Dual mode as i want to do some tables as 'In Memory' and some tables as "Direct Query" implementation.

    I want to improve our PowerBi performance using 'Direct Query' Model so i want to use Analysis Service in Dual mode as i want to do some tables as 'In Memory' and some tables as "Direct Query" implementation to make help in Query Performance .

    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 →
  19. 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
    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. .NET core web app needs client library to query Azure Analysis Server for data

    ADOMD does not work with .NET core web app. Which library should i download so my .NET core web can query data in Azure Analysis Server?

    4 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