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. Add a "process upon table import" option/toggle for in-memory models

    Sometimes you don't want to process a table after importing it (using the Query Editor in SSDT). Instead you only want to add the table structure and query expression to the model.bim file.
    Then if you want to later you can use SSDT's process partition/table/all button, or you can use SSMS to connect to the workspace server and process your database for a faster processing experience.

    7 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. Add Team Service source control to the new Azure Analysis Services Web Designer

    Add Team Services as a source control open for the new Azure AS Web Designer

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

    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. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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

    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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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.

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

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

    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 →
  18. 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 →
  19. 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 →
  20. 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
    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