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. Outer join relationship

    Sometimes you have a business requirement where there is a measure in a Sales Order Header fact table but then you need to join to a table of zero-to-many salespeople associated with the order. The business would like to see the sales measure repeated when there are multiple salespeople. But the business would like to show a blank salesperson (without losing the sales order header row) when there are zero salespeople associated with an order. Essentially this is a left outer join to a table.

    Certainly you can write a custom DAX query to do this with the NATURALLEFTOUTERJOIN DAX…

    10 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. Option to allow all Azure services through the firewall

    Azure Analysis Services has a firewall option since 2017. However, there is only a tick box to allow Power BI to access it. For every other Azure service, you manually need to add the IP address ranges of the specific datacenter region to the firewall. This is manual labor, prone to errors and not like some other services such as SQL server, Storage Accounts and Key Vault which do provide an easy tick box to allow all Azure services.

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

    9 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. Get visuals back after importing pbix file

    After importing a PBIX file, I have to rebuild my visuals, would be great if you could get a pbix back after importing that has the same visuals but now connected to the new AAS model.

    9 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 Analysis Services model as data source itself

    Allow for having a central/master AAS tabular semantic model that is a source for some satellite AAS semantic models (import or live, the latter ideal) that are consumed in live connection mode with tools like Power BI.

    9 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. Process Azure Analysis Services Tabular Model from Data Factory

    This idea consist in being able to process an Analysis Services Model from Data Factory.
    Ideally using the Data Factory Managed Identity.

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

    8 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 →
  8. Add ability to use Event Stream & Event File targets for xEvent Sessions

    xEvents are tremendously helpful for monitoring and troubleshooting performance issues.

    Ideally we'd get both "Event Stream" and "Event File" targets as there are good use cases for both.

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

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

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

    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 →
  12. AAS Web designer - edit Model

    To be able to edit model (add new tables, fields) in AAS Web designer. Currently a new model has to be added, if any structural change takes place in Azure SQL database.

    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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. .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?

    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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
  • Don't see your idea?

Azure Analysis Services

Categories

Feedback and Knowledge Base