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.

  1. 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.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. To provide the information regarding how to customise the upload time in Azure Analysis Services

    To provide the information regarding how to customise the upload time in Azure Analysis Services. It seems the default upload time is set to around 4 min. What if we need to upload bigger files?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add more data connectors to AAS web designer

    The AAS web designer preview is out for almost 2 years, yet it still supports only 3 data sources when creating a new data model. This is unusable in most scenarios. This is especially ridiculous when there is Power Query built-in already in AAS. As a starter, a simple data connectors like "Common Data Service", "Power BI Dataflows" or "M Script" would be sufficient for getting past that weird limitation.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Spark Connector in Azure Analysis Services isn't working

    Spark Connector for Azure Analysis Services doesn't seem to be working. I attempted different connstr including the one used successfully in Power BI. Nothing seems to work. No documentation either.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. link protocol doesn't work correctly with power bi and dual factor auth

    we have setup aas with a link protocol and all users have dual factor authentication as per https://community.powerbi.com/t5/Issues/Azure-Analysis-Service-live-connection-issue-with-a-pbit/idi-p/550868 .

    In powerBI if you use the link:// protocol to connect you have to go through the dual factor twice on a pbix and on a pbit (template) when you reopen it it throws up 12 dual factor auth boxes and will return an error. Not sure if the problem is power bi or whether it is the client libs but raising here. Using Oct 2018 PBID and 15.0.2.39 client library.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. memorize dax query after having switched to model panel

    currently if you write a query in DAX, and you run it, you can see the result
    BUT if you switch to the MODEL view, and then go back to the DAX query tab, everything shown previously is reset (it would be great to keep it). it's like if when you go back to that interface you are actually refreshing the page

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. query tables of the model in t-sql

    possibility of querying tables of the model in t-sql besides dax

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. save queries like in log analytics or app insights

    Once Ia DAX query has been written (or generated) it would be nice to have a SAVE QUERY, so that for testing data within the model it's easier to rerun

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. No way to chart duration in Log Analytics?!!

    Perhaps I am doing something wrong but in Log Analytics there is a Duration_s column that provides the length of time of a query_end event but as it is a string (_s) it is not available to be added to the x axis.

    This seems like a pretty basic requirement of Log Analytics to chart duration. Why was duration created as a string when surely it is really numeric?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. link protocol should support on prem SSAS

    https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-server-alias indicates that the link:// protocol can only be used with Azure Analysis Services but this (combined with the fact that we can't automate the changing of connection strings in PowerBI.com means that a migration from onprem to PAS is a one-way operation which makes the change boards very uncomfortable.

    Please allow this to point to both onprem and PAS SSAS instances

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Load balancing and/or Failover On-Premises SSAS and Azure Analysis Services

    Access to Azure SSAS servers can be aliased using link:// in Power BI Desktop, thus allowing admins to load balance with Traffic manager and move models without redeployment. However this approach does not work with with on-premise SSAS servers since they do not present an https endpoint by default and is accessed by the cloud service via the Azure Gateway. Could you please provide an option for load bursting or even just failover from on-prem to Azure?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Copy and Past option to simply copy a table from diagram view

    There is no copy and past option in Diagram /Grid view to copy and paste the table. Sometimes reporting team requires same copy of existing table for achieving the functionality of Chart As. In this case copy and past is very useful

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Parse out Admin Rights on SSAS for Deployments

    My company has strict security requirements and without a clear way to isolate the ability for a developer to easily and with agility deploy their SSAS solutions to either the Development Server or Production Server we will be unable to use SSAS Tabular as our strategic data modeling/semantic tool going forward. The easiest solution for us would be to parse out the Admin Permissions or allow for a Custom Role to allow a development team to deploy to a shared SSAS Server (shared amongst different application teams from different lines of business where data isolation is imperative) in (Dev or…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Have server names change when connection changes

    It would be useful if it were possible to change the server name in Analysis Services by changing the connection for the cube.

    It's inconvenient that we have to recreate the server to change the name.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Create 'Export To Text' button when viewing the Model in Script Mode

    Right now when you view the model as a script if you copy and paste this to use it will be decorated with "" so it's not valid JSON.

    Would be better to have an export button so we can easily use the script.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. blanks excel

    Fix or at least provide an option to suppress showing of blanks where there are no blanks in the relevant table column in client tools (Pivot Table, Power BI)

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Support for Encryption At Rest

    Possibly more relevant for on-prem, but it would be really useful if SSAS databases had something like TDE (Transparent Data Encryption) so that all data files and backups were encrypted at the point they were written to disk. I know with things like MD cubes this might impact performance but if Tabular is In-Memory perhaps it's not such an issue?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Create more granular operations for a custom role based access control

    The operations listed for custom roles for analysis services is quite limited.

    https://docs.microsoft.com/en-us/azure/active-directory/role-based-access-control-resource-provider-operations#microsoftanalysisservices

    For example, it would be great if more operations could be created so that a developer could create databases but not delete them - or only delete databases that they have created.

    A large instance of Azure Analysis Services may host multiple models from different entities and it would be great to give more granular access to developers at the entity level instead of at the Corporate IT level.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. date format

    Add Data Format "dd/MM/yyyy" for Data Type "Date".

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Azure Analysis Services

Feedback and Knowledge Base