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.
-
Diagram lacks functionality
If you compare the Diagram functionality withing Tabular Analysis Services to Dimensional Analysis Services, the tabular one is too simple.
The dimensional one has a possiblity to create "layers" or views which can reduce the complexity.Please make it possible that
- You can create multiple diagrams within Tabular AS.
- You can save those diagrams within the BIM file.
- When you create an ASDDatbase file, it should contain those diagrams.
- You should be able to view the diagrams in SQL Management Studio just like a SQL Database.
- You should be able to view the diagrams when…4 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.6 votes -
Maintenance Windows on AAS
As with other hosted services, uptime and predictability are crucial for our users. We need to have a way of knowing when the server will be brought down for maintenance so we can schedule processing around it and notify our users well in advance.
The best way would be to implement maintenance windows, like SQL DWH, but a short-term fix could be to implement notifications BEFORE server downtime.
Two times in the last week, our automated nightly processing has been interrupted by "Server upgrade/restart". As this is a long-running processing and it is interrupted at the tail-end of the process,…
20 votes -
does Azure Analysis Service support Azure databricks delta table ?
does Azure Analysis Service supports Azure databricks delta table ? If yes How does it ?
20 votes -
Dynamic Format String based on DAX Expression
Allow the Format String property for a measure to be determined by the results of a DAX Expression.
This would be similar to the approach in the below link. However, instead of using the FORMAT() function within the measure's DAX expression, the format should be able to dynamically be set using the Format String property of the measure.
https://christianwade.wordpress.com/2012/08/21/currency-conversion-formatting-symbols-in-tabular/
19 votes -
system-assigned managed identity
It would be nice to allow the creation of system-assigned managed identity this would unblock the ability to use AAS to authenticate directly to a data source such as Azure SQL DB without using a user-created service principal or relying on sql authentication which uses OAuth2 credentials that expire
https://docs.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/overview
22 votesWill follow-up with the team on this. Stay tuned!
-
Importante analisar todos os serviços em descrição ao servir os usuários que comentam
Auto analisar os serviços prestados pelos os sites Microsoft Azure e os demais.
1 vote -
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 -
HANA DirectQuery for Azure Analysis Services
It's available for PBI, would be nice to have it on Azure Analysis Services as well so we can build and manage our models in a single place. Doesn't make sense to pull data from one in-memory solution to another.
4 votes -
Snowflake connector for Azure Analysis Service
Please create a connector for Snowflake in Azure Analysis Service. Having to use a on-premise gateway does not really make sense.
81 votes -
parquet fle data source
add support to parquet file as a data source
2 votes -
Firewall Rules DeployifNotExist Policy to check compliance
We are wanting to implement a policy that will deploy firewall rules through policy to Azure Analysis Server. Every scenario I tried doesn't seem to work. It looks like the Existence condition doesn't like the alias's for this service. I could be doing something wrong, but if there is a way or could be a way to do this, that would be great. It appears within the Api there is not an Enable Option for the firewall to set to true, so wondering if that may be the problem.
1 vote -
Allow backup and restore of AAS "server" settings.
Allow restore of AAS "server" settings. Currently we can capture the settings using XMLA query, but there is no method to restore those settings to another AAS server (e.g. for DR or HA purposes).
1 vote -
in results to grid in SSMS, maintain CR/LF
In the results of a DAX query against a AAS cube, the results don't maintain line breaks or other formatting.
2 votes -
1 vote
-
BUG : datediff gives an error when startdate is bigger then enddate
Clearly stated in the documentation https://docs.microsoft.com/en-us/dax/datediff-function-dax but in other systems (Excel/SQL) it should return negative values
2 votes -
Support parameter validation for AAS REST API
Currently I get a 500 error if I send a mal-formed JSON payload, this should be a 400 error with a meaningful message
{'error':{'code':'InternalError','subCode':0,'message':'An internal error occurred.','timeStamp':'2020-03-06T10:50:57.1721115Z','httpStatusCode':500,'details':[{'code':'RootActivityId','message':'ce5ce935-2702-4023-b2f1-69abcc1a0c34'},{'code':'Param1','message':'Object reference not set to an instance of an object.'}]}}
1 vote -
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.
8 votes -
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.14 votes -
Support ADLS Gen2
Please add ADLS Gen2 as a supported data source to Azure Analysis Services.
8 votes
- Don't see your idea?