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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. edit url for data lake

    My project requirements dictate a need for the a Tabular Model Connector to Azure Data Lake which lets you change folder so you can deploy a project file to different clients without having to edit the model file.

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

    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 →
1 2 3 4 5 6 8 Next →
  • Don't see your idea?

Azure Analysis Services

Categories

Feedback and Knowledge Base