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

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

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

    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 →
  4. Azure Analysis Services Model as Data Source in Azure Analysis Services.

    I would like to be able to call an Azure Analysis Services Model as a source for my Azure Analysis Services model. We have models on prem that call each other. I'm trying to shift them to the cloud. But apparently they cannot call each other as sources there.

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

    Add option to enable Private Link/private Endpoints for Analysis Services. vNET integration, similar to how many other Azure resources can integrate with Private IP addresses and DNS, would help many teams to simplify designs for connecting to other services such as SQL DB/Synapse.

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

    8 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 →
  12. 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?

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

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

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

Azure Analysis Services

Categories

Feedback and Knowledge Base