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.
-
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 -
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 -
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 -
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 -
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 -
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 -
Support ADLS Gen2
Please add ADLS Gen2 as a supported data source to Azure Analysis Services.
8 votes -
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 votesWe are evaluating whether to allow access to file targets for xEvents, or to surface this information through the standard Azure mechanisms.
-
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 -
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 -
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 -
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 -
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 -
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 votesWe are looking to add git support. Would that handle what you need?
-
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 -
.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 -
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 -
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,5TB6 votes -
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 -
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
- Don't see your idea?