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.

How can we improve Microsoft Azure Analysis Services?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. 1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
    • Support Always Encrypted Columns for Azure SQL Database

      It would be great to support the use of Azure SQL Database Always Encrypted Columns in Azure Analysis Services. One scenario could be decrypting while importing (or reading via direct query), another advanced scenario might be storing the encrypted data and de-crypting when reading from AAS.

      1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • For Azure service, there is “Always On” option; default is “off” and this better be “on” by default.

        For Azure service, there is “Always On” option; default is “off” and this better be “on” by default. Some prod service was off unexpectedly during the weekend because of this.

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          2 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Get visuals back after importing pbix file

          After importing a PBIX file, I have to rebuild my visuals, would be great if you could get a pbix back after importing that has the same visuals but now connected to the new AAS model.

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • AAS Web designer - edit Model

            To be able to edit model (add new tables, fields) in AAS Web designer. Currently a new model has to be added, if any structural change takes place in Azure SQL database.

            2 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Support AAD authentication for Azure SQL DB datasources

              Azure SQL Database supports the use of AAD authentication:

              https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure

              This authentication type is not supported when attempting to connect to an Azure SQL database from Azure Analysis Services.

              I was fairly surprised to see that this authentication mechanism wasn't working between the two products. The issue has been confirmed via a support ticket with Microsoft, whom suggested raising it as an idea here.

              AAS team, please add support for AAD authentication when using Azure DB as a datasource from Azure Analysis Services.

              Thank you.

              6 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Azure Analysis Services model as data source itself

                Allow for having a central/master AAS tabular semantic model that is a source for some satellite AAS semantic models (import or live, the latter ideal) that are consumed in live connection mode with tools like Power BI.

                3 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                • Outer join relationship

                  Sometimes you have a business requirement where there is a measure in a Sales Order Header fact table but then you need to join to a table of zero-to-many salespeople associated with the order. The business would like to see the sales measure repeated when there are multiple salespeople. But the business would like to show a blank salesperson (without losing the sales order header row) when there are zero salespeople associated with an order. Essentially this is a left outer join to a table.

                  Certainly you can write a custom DAX query to do this with the NATURALLEFTOUTERJOIN DAX…

                  3 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • In SSDT allow us to review the tables brought in by an M query

                    If you decide to change your M query for a table, with the typical case being that you needed to add an additional column, you currently have to edit the model.bim file to add the new column into your actual table object.

                    This new feature would allow us to see what columns get surfaced by the M query and select which ones we want imported into the model (which would typically be all of them, because otherwise you would have excluded the column in your m query).

                    2 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Allow to change the service account

                      As a best practice, we'd typically use Windows auth for on-prem SSAS where the SSAS service account is granted access to the data source to process the model. Allow us to change the Azure AS service account to be used when processing from SQL Server.

                      2 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Improve the error logging when Visual Studio crashes

                        It's not always easy to re-produce a crash in SSDT, and at times it can feel like the crash was due to typing out a measure too quickly, coming up with wacky m queries, or perhaps even because it is too windy outside. An improved error log would at least give me some solace that SSDT isn't prejudicing my model development due to my taste in music.

                        2 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Add a "process upon table import" option/toggle for in-memory models

                          Sometimes you don't want to process a table after importing it (using the Query Editor in SSDT). Instead you only want to add the table structure and query expression to the model.bim file.
                          Then if you want to later you can use SSDT's process partition/table/all button, or you can use SSMS to connect to the workspace server and process your database for a faster processing experience.

                          4 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

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

                            3 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Create a "metadata" model.bim template that can target a specific Analysis Services database

                              Business users and report-writers that interface with the tabular model often have many questions about what the relationships between tables are, what the specific measure definitions are, or just want to know general description information about the model.

                              While I can create a generic "metadata" model myself that connects to a targeted AS database's DMVs, it'd be nice if Microsoft created a standard template as a model.bim file and published it so that we can very easily edit the datasource to select our targeted model.

                              3 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

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

                                3 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                • Basic filter improvement

                                  Query section -> filters -> Basic
                                  What is now, the basic filter provides including different rows of 1 column, implemented as a simple select(dropdown menu). But if I need to select a big number of rows at once, I have to search select each of them so many times. To my mind, it is better to customize the choice, because it may be sometimes disgusting to pick every.

                                  1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add Team Service source control to the new Azure Analysis Services Web Designer

                                    Add Team Services as a source control open for the new Azure AS Web Designer

                                    5 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • T

                                      T

                                      2 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Include all Power BI Data Connectors in AAS

                                        Azure Analysis Services has a limited number of data connectors compared with Power BI. Without access to the same data connectors, it will be impossible to import Power BI files into AAS without a lot of re-building data integration steps using other methods.

                                        Here is the current list of NON-BETA connectors Power BI has that AAS does not:

                                        - Amazon Redshift
                                        - Azure Data Lake Store
                                        - Blank Query
                                        - Facebook
                                        - Google Analytics
                                        - Hadoop File (HDFS)
                                        - IBM DB2 Database
                                        - Impala
                                        - Power BI Service
                                        - R Script
                                        - SalesForce Objects
                                        - SalseForce Reports
                                        - SharePoint Folder …

                                        23 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Highly Available Azure Cubes

                                          I would like to see a feature in Azure analysis service where when if a server or cube is getting processed the report connection can be redirected to another server. This functionality can be done in on premise cubes with help of load balancer and shell scripts. Anything of this sort on Azure can be great full.

                                          5 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Azure Analysis Services

                                          Feedback and Knowledge Base