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.
-
Allow user priority to boost users' execution priority
It would be really useful to allow a user priority value, so users with higher priorities get execution priority too, and their queries will preempt lower priority requests.
2 votes -
QPU Percent Utilisation metric for Azure Analysis Services
There's no metric available for Azure Analysis Services to show the percent utilisation of QPU - only absolute QPU usage.
This makes it hard to alert on because a single threshold value won't scale with the size of the instance.
Azure SQL offers a DTU percent consumption metric which is a function of usage/DTU limit of the instance.
Is there a good reason the equivalent can't be added for AAS?
2 votes -
Azure Portal Metrics AAS - split by database
Would be great to be able to use database as a splitting variable when analyzing metrics in the portal for AAS. For example, I am interested to know the memory consumption of each DB on the server, but that can only be achieved right now through DMVs.
2 votes -
Open Source Web Designer (Now Deprecated)?
Even though I knew it was slated for deprecation, I was still sad seeing the web designer go. It was a really well done piece of software. Yeah, the pbix import was a nice to have but tbh what blew me away was its usefulness as querying / exploration tool. The interface was top notch supporting both casual browsing via drag and drop as well as the query editor for more advanced authoring. Any chance we could see the tool (or snippets of it) open sourced? : )
2 votes -
RetainPartitions
Need an option to use the RetainPartitions from MD on Tabular as manually adding partitions instead for having and automated process is not ideal.
2 votes -
Client libraries for JavaScript/TypeScript clients
Currently, there are no officially supported client libraries available for NodeJS clients built using JS/TypeScript languages. The only way to access data from tabular models/cubes is to use another wrapper C# service and talk to that service from the NodeJS client (see this forum post for context: https://social.msdn.microsoft.com/Forums/en-US/cb5c7edb-5eeb-41dd-b59b-f40253bf5e69/nodejstypescript-client-library-support-of-azure-as?forum=AzureAnalysisServices)
It would be great to have an official library package for these kinds of clients.
2 votes -
Respect data types when AAS model is being viewed in Excel
We have found that when viewing a cube pivot based on AAS that all data values are imported as string, regardless of the type set in the model.
This is in spite of the fact that when viewing standard Tabular Analysis Services models in Excel data types are respected.
Recognising data types allows for the creation of date hierarchies and mitigates sorting issues that occur when sorting by text values.
Please import data into the correct types when an AAS model is being viewed in Excel.2 votes -
Allow connection to each replica
Scenario 1: I need to check whether any queries are running on any replicas before I pause the Azure Analysis Services instance.
Scenario 2: I need to find and cancel any queries which have been running for more than 5 minutes and I can't control the Timeout connection string property in the client tool such as in Power BI.
I would like to have some new syntax which lets me connect to each query replica with the following server name:
asazure://southcentralus.asazure.windows.net/servername:ro1
asazure://southcentralus.asazure.windows.net/servername:ro2The :ro1 and :ro2 syntax would let me connect to query replica 1 and 2.
2 votes -
Support for username() and userprinciplename() in calculated columns
Currently Azure Analysis services does not support many DAX functions such as username(), lookupvalue() etc. in calculated columns. There are requirements from clients to customize column values based on logged in user which cannot be implemented without these functions in calculated columns. Azure Analysis services should support all these functions to cater these requirements as they are vital for BI.
2 votes -
Required Connection to Cosmos DB
Please provide a connection to Cosmos DB from Azure Analysis service with JSON schema option
2 votes -
Bring Upgrade Analytics to Azure Government OMS
Upgrade Analytics to Azure Government OMS
2 votes -
Making Azure Analysis service a Self Service Data Preparation platform i.e. similar to PAXATA
Making Azure Analysis service a Self Service Data Preparation platform i.e. similar to PAXATA
Actually I don't see how AAS can be used for Self-data Preparation, majority of business users look to something similar to PAXATA.
2 votes -
Required Filter at Perspective
Scenario
I have a cube (tabular model)
It contains a list of Customers, and a measure Revenue.
The Customer table has a column Client Account Manager.
I will have a report which points to this default perspective, and the Security Role will apply Row Level Security showing only the Client Account Manager their Revenue, for their Customers. Simple.For Account Managers & Non-account managers, I also want them to be able to see the revenue for any Customer, even if it is not their own, but I don’t want them to be able to write a report (or remove a…
2 votes -
For Azure service, there is “Always On” option; default is “off” and this better be “on” by default.
For Azure service, there is “Always On” option; default is “off” and this better be “on” by default. Some prod service was off unexpectedly during the weekend because of this.
2 votes -
T
T
2 votes -
Query for Azure Analysis Services Tabular
I want to use Azure Analysis Services Tabular for Power BI Services with over 1 GB data models.
My query use the Query in most case Power BI without developers.
I hope Azure Analysis Services with the Query feature.2 votes -
Allow support to add a Private Endpoint/Link to the Azure Analysis Services
If the feature to add a Private Endpoint/Link to the AAS would be added. Then the whitelisting on the AAS firewall can be exchanged for the use of a P2S VPN. This way everyone can make a Private connection with the SSAS while they are working from the SSMS. This would also make it a ton easier to manage and of course more secured.
1 vote -
1 vote
-
Extend Security to Perspectives
Extending the Security model to perspectives would enable Adminstrators to better control the user experience and eliminate confusion with complex data models.
Ex. 3 Perspectives - National, East and West
3 Roles - National , East and West
3 Users - National Bob, NY Eddie and California JoeEach Perspective has is has only 1 role associated. National Bob is member of all 3 Roles. NY Eddie = East, California Job = West.
National Bob can attach to all 3 perspectives and the Geography dimenstion is limited to the values specified by Role associated with that Perspective.
NY Eddie and…
1 vote -
1 vote
- Don't see your idea?