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.
-
Add support for service principle authentication
I'd like to be able to refresh cube partitions from within data factory.
I've got an Azure Batch process that runs a class using the AMO library, however the authentication options are limited - I can either hard code an AD username and password into the connection string, or run the application from an authorised account (which I don't think is possible in azure batch).
Support for more forms of authentication would enable cube refreshes from data factory / azure batch.
17 votesWe do support service principals. The next SSMS will make them a lot easier to set in roles and we also have some client lib changes that will make them easier to use. Now you can use them by getting the token yourself and passing it in as the password on the connection string.
-
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.
16 votes -
16 votes
-
Feature to alert about insufficient memory or server unavailable
Can you please provide a feature which can send an alert notifying about insufficient memory for analysis server pricing tier , unavailability of server with the reason.
16 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 -
Key Vault for Connection string using secrets
The Key Vault implementation is widely accepted for security reasons and greatly simplifies the work of rotating / change passwords using secrets. When you have a big number of models this becomes a tedious job if you have hundred of models on top of a data warehouse.
The super awesomeness would be to be able to configure and entire connection from the secrets. When changing environments (Dev to QA or QA to Prod) would just take changing Key Vaults.
15 votes -
Support for SSAS row level filters and column level security combined in the same model
Currently SSAS 2017 security roles supports either row level filters or column level visibility only at a time. Both type of security at the same role is not supported now.
Also currently in SSAS the same user cannot be in roles that has row level security in one role, and column level access in another role. Please see the link below for the limitation:
https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/object-level-security?view=sql-server-2017However, there are requirements where users needs to be restricted by row level and column level both at the same time. SSAS should support this.
15 votes -
Automate On-premise gateway installation
We're looking for a way to automate the install of the on-premise gateway to allow it to scale through automation. Passing parameters for Email, Gateway name, Recovery key, pass the recovery key to KeyVault, etc.
15 votes -
Azure Analysis Services Automated Refresh for Excel Online
Excel Desktop PowerPivot Report connected to Azure Analysis Services Tabular model refreshing the data works in Excel Desktop.
However, when you publish this workbook to Power BI workspace (from the workbook's ribbon menu > File > Publish > Publish To Power BI) then you try to refresh the data in Excel Online it doesn't work!!!
Microsoft should fix this limitation otherwise what's the point of having a refresh capabilities for just Excel Desktop PowerPivot.
We want our end users to be able to refresh powerpivot reports Online.15 votes -
In SSDT's Tabular Model Explorer, arrange measures according to their display folders
This one's pretty straight forward, the current experience for managing measures in each table becomes "clunky" when you start hitting more than >100 measures. While low priority, it'd be nice to change up this experience and organize the measures into folders for a better management experience.
15 votes -
Enable user mapping - multi domain
On a SSAS connection in the Power BI service, we can easily map end-users from different domains to the AD of the SSAS.
With SSAS on Azure, we're stuck to the default AD, which is blocking several scenarios.
Please add this flexibiliy to (e.g. by adding this mapping functionality)15 votes -
Support ability to get the logs of queries, users who executed them, and time it took for queries to run on my AAS instance
Would like the ability to get the logs of queries, users who executed them, and time it took for queries to run on my AAS instance. I would like to keep track of this data so I can see if read performance gets worse, which users use the AAS instance the most, and which kind of queries users run so I can optimize for them, for example.
14 votes -
Azure Analysis Services add Firewall option
Firewall option for Azure Analysis Services (SaaS) is not available. It would be very helpful to convince some of the customers that is skeptical to use SaaS services because of Public Endpoint. Probably can apply the same solution as Firewall on Azure SQL Server.
14 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.13 votes -
Ability to share common components (tables,perspectives etc) between tabular models
Having the ability to have a re-usable shared library of components would help to:
- Reduce the time taken to develop and maintain components used across multiple models
- Encourage the development of smaller, more focussed models
- Reduce the memory overhead for common shared objects. For example, where models are hosted within the same Analysis Services instance shared components could be loaded once in a ‘central’ model, this single repository of data could then be referenced by other models hosted within the same analysis services instance.We’d need the ability to link the central tables and resulting objects into…
13 votes -
Add an "Analyze in Power BI Desktop" button to SSDT-Tabular
Basically the same functionality as the existing "Analyze in Excel" button found in the top icon bar when developing tabular models in SSDT/VS... only tied to Power BI Desktop instead of excel.
13 votes -
Cover Azure Analysis Services in the HIPAA BAA
Please add Azure Analysis Services to the HIPAA BAA so we can use it in healthcare software.
13 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.
12 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.
10 votes -
Use Analysis Service in Dual mode as i want to do some tables as 'In Memory' and some tables as "Direct Query" implementation.
I want to improve our PowerBi performance using 'Direct Query' Model so i want to use Analysis Service in Dual mode as i want to do some tables as 'In Memory' and some tables as "Direct Query" implementation to make help in Query Performance .
10 votes
- Don't see your idea?