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.
-
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.
44 votes -
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 -
Allow "With Measure" to specify a format string
When writing an MDX query a "With Member" clause can optionally add a Format_String to the declaration.
It would be very useful to have this option for "With Measure" DAX clauses too.
For example a column can have a FormatString specified in the model, but there is no way to use this in an MDX query if you write
With Measure 'Table'[Sum of Amount] = Sum('Table'[Amount])1 vote -
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.
17 votes -
xirr
Power BI report, Azure Analysis Services XIRR function return "The XIRR function couldn't find a solution" when the investment data set loss is huge,or/and multiple rate of returns is possible.
1 vote -
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 -
Enable OAuth2 support for Direct Query
Enable OAuth2 Support for Direct Query. Certain organizations are locked down and cannot use SQL login etc
1 vote -
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 -
1 vote
-
Unable to Slice from Outrigger Dimensions
I see an issue while querying data from an Outrigger Dimension, for example DimAddress have DimState and DimZip as Foreign keys from different dimensions and when I using the above dimensions as filters, the result I see from the Outrigger Dimension in this case, Dim Address is a Cartesian product.
Also goes for the fact tables if defined as dimension but not as a measure group would result in Cartesian product. Please let me know how to resolve this problem.
1 vote -
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 -
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
- Don't see your idea?