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. 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 →
  2. 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 →
  3. 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 →
  4. No way to chart duration in Log Analytics?!!

    Perhaps I am doing something wrong but in Log Analytics there is a Durations column that provides the length of time of a queryend 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
1 2 5 6 7 9 Next →
  • Don't see your idea?

Azure Analysis Services

Categories

Feedback and Knowledge Base