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.
-
Enable users to update table schema during a database or Table process/refresh
At present, it is not possible to dynamically update your table schema using steps in your table definition / Power Query.
i.e Dynamically:
Generate a new column OR
Set a column data type of the newly created fieldConsider a scenario where your table is created from a step that aims to dynamically generate a new column based on a transform step. See two Example transform images attached.
It has been confirmed that there is no way to enable this Dynamically or programmatically update the table schema/defination via a Database or Table process/refresh option.
(Process Default, Process etc.)You…
15 votes -
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.
20 votes -
Direct Query between Azure Analysis Services and Snowflake
Currently, we are using the on-premise data gateway to connect Azure Analysis services to Snowflake.
Instead, it would be great to have a direct query connection established between Azure Analysis services and Snowflake.4 votes -
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.
9 votes -
Auto token refresh with MFA enabled
Auto token refresh in AAS is still not possible with MFA enabled currently, please consider to integrate the auto token refresh feature with MFA as MFA is required to secure AAD account sign in
2 votes -
Invoke-ASCmd for PowerShell Core
Currently, the module SqlServer doesn't import all cmdlets when running PowerShell Core.
I find this very confusing because there is no place in the Azure documentation that mentions this restriction. Actually, the documentation promotes the usage of the Invoke-ASCmd in multiple situations but doesn't mention that this can't be run in Azure services like Function App or App Service because they use PowerShell Core.
The only alternative I could find is to run the same on a Virtual Machine, that's something that I didn't want to do: I have to do all the start-stop mechanisms to simulate something "serverless".
Here's…
4 votes -
Elastic pool concept for Azure Analysis Services
Elastic pool concept for Azure Analysis Services.
1 vote -
1 vote
-
Easy data masking
We would to have the ability to mask data of a specific column depending on the user role.
At the moment it is possible to hide a specific column by creating a new role. This option has some idiosyncrasies, because when you have a column that appears on a PowerBI report, the reports crashes for users with this specific role. This because the column is hidden.
1 vote -
Upgrade from S4 to S8 v2 , will query replicas remain same ?
I have upgraded my AAS server in East US 2 from S4 with 2 query replicas to S8 v2 . The query replica are still showing 2 after upgrade . But, as per https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview , max replicas allowed for S8 v2 in East US 2 is only 1. Is it an issue with azure portal or the no. of replicas created remain intact after upgrade ?
1 vote -
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
-
auto-restart
Update Azure Analysis services so it auto-pauses after 1 hour of inactivity and then auto-restarts when the first person tries to access it similar to the functionality for Azure SQL Server.
4 votes -
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 -
Add created Date and Time field to $SYSTEM.TMSCHEMA_MEASURES
Hi, I would like to apologies for posting a non AAS idea on this. My request is for SSAS and I wasn't sure of the right place to post it.
I would like to have a new field added to the view $SYSTEM.TMSCHEMA_MEASURES. Currently we only have ModifiedTime but we would like to see create date and time as well for measures for tracking purposes.
Appreciate if you can take a look into this.
1 vote -
No option to delete tabular Model
No option to delete tabular Model
1 vote -
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.13 votes -
Service Fabric update should happen during the weekend on Azure Analysis Servers
Service Fabric update should happen during the weekend on Azure Analysis Servers so no any customer and stack holder face any issue during the business hours or during the model refresh processing.
1 vote -
Advance notification for Service Fabric update on Azure Analysis Services
There should be advanced notification of service fabric update that happens on Azure Analysis Servers coz it happens at random time without intimation which affects refresh of model and lead to escalation from the stack holders which overall impact the end users.
1 vote -
Each Model Size from Azure Analysis Server
Requesting you to have direct approach of checking size of each model into analysis server.
There is powershell script available to check but that shows wrong size of model and whenever we ask MS to provide size of each model then they give us in tabular format.
Same way we need to have a report so every time we don't need to approach MS to collect the data for us.
1 vote
- Don't see your idea?