Power BI Ideas

How can we improve Power BI?

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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Python Script in Power BI

    It's great that Power BI already has the capability to run R scripts for data transformation. It would be even better if we could run Python script.

    573 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

      24 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
    • Aggregation of measure for different date dimensions

      There is a need to aggregate a measure for different date dimensions. Today we are required to create a separate measure for every such instance. e.g. Sales basis users joining date or sales basis opportunity close date or sales basis opportunity created date.

      In order to achieve this we are required to create multiple measures. It would be great if we have a standard Calendar available and we are only required to link the dates to the Calendar and the standard sales measure.

      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

        1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
      • TopN Filter for Page Level and Report Level

        Currently, if I want to filter my entire report by the Top N items, I have to apply the Top N filter to each and every Visualization that I create in the report. I would like to be able to add a Top N filter to the Page or Report Level, then the affected Page or Report would only contain data from the items that were selected with the Top N filter.

        7 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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
        • R-Skript-Datasource/"Run R Script"-Transformation without Personal Gateway

          As discussed in

          http://community.powerbi.com/t5/Service/Understanding-how-R-Scripts-work-in-Power-BI-Service/m-p/328687#M37427

          it would be nice to be able to use "R-Skript" as a Datasource with public accessible Data - from websites for Example - and the Transformation "Run R Script" in the Query Editor without using a "Personal Gatway" and therefore relying on my local machine which is not practical in a productive BI environment.

          At the moment, it´s not possible to use "R" or "Run R Script" "stand alone" in the service, would have been pretty great if I could use R for data wrangling instead of M/Power Query with the "Run R Script"-Option. This would…

          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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
          • Create multiple columns at once

            Please give a functionality to create multiple columns and measures in one go.

            When working on creating the dashboard, we always have to create one column at a time, this makes it difficult to work and a tedious task to perform various transactions in one go. Instead it will be much better if we could create multiple columns in one go.
            It could be like an advanced editor which is used on the query side.

            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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
            • 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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
              • Master App

                We have currently created numerous apps for different parts of the business using a single App Workspace each time. We now have a request to combine these Apps and possibly remove unwanted content for adoption purposes. We could of course create another app but that would mean duplication of reports .pbix files.

                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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                • easily filter tables based on values of another table, with query folding

                  Currently it's not easy to remove dimension table records with the Query Editor that are not related to the main fact table.
                  Let's say you have a Product_ID in the fact table, and the fact table (sales) only contains records for the last two years. I'm missing an easy way of removing the records in the Product table (that are related to the fact table via Product_ID) that are not related to the fact table.
                  When I set up a solution with a merge, I can not make the query fold to sql anymore. The new feature should be easy…

                  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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                  • Append multiple queries dialog should list the queries in alphabetical order

                    The "append 3 or more tables" dialog in Power Query is great, until you have more queries than you can see without scrolling. Unfortunately, the dialog returns the queries in the order they were created, rather than alphabetical order. Can you please either make it default to alphabetical or give us the option of ordering?

                    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

                      1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                    • profiling column values

                      Automated column profiling:
                      when data from any source is transformed into a table form, an automated profiling of the values in each column displayed in the form of a histogram just above each column header can give a really good insight about the data quality and further aid the analyst in guiding through the data preparation process.

                      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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add function IFBLANK(Value, Alternate)

                        Add function IFBLANK(Value, Alternate) similar to IFERROR().

                        This would prevent having to constantly write:
                        IF(ISBLANK(Value), Alternate, Value).

                        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

                          2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                        • Use camelCase or PascalCase for Query Editor Option

                          I would like a setting that would allow the ability to remove all the spaces in the names generated by the Query Editor.

                          by default options are added like "Added Items" or "Filtered Rows" While this makes it readable it makes it hard because in the query editor there are a bunch of quotes.

                          I would like the option to change this to either PascalCase or camelCase.

                          13 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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                          • Detect Zip Codes (and Change Type) Based on Column Headers

                            Zip codes typically import as numerical but if they lead with a 0 it doesn't show making it inaccurate. On top of this, some countries have letters. It would be nice and low cost to be able to have PowerBI recognize a column header labeled "zip" "zip code" or "postal code" to automatically change to text from number when data is imported.

                            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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                            • Parse JSON Support in DirectQuery and Query Folding

                              Currently, Parse JSON is not supported in DirectQuery for a SQL Server database connection. I know JSON functions were not added until SQL 2016+, but it would be nice to be able to take advantage of those in DirectQuery and Query-Folding in Power BI if the database version supports it.

                              There may be other data platforms that have JSON functions and could take advantage of this as well.

                              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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add a widget that can summon Aleister Crowley

                                Add a widget that can summon Aleister Crowley

                                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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                • View records causing Expression.Error

                                  When a step in a query causes an Expression Error, the best troubleshooting that can be done in the editor is, starting from the last step, to click step-by-step through the Applied Steps to find which step is causing the error. The error does not give much detail -- for example, "There were too many elements in the enumeration to complete the operation," followed by "Details: List". It would be extremely helpful if the editor could show the offending records causing the error, like an IDE indicates syntax errors in code or returns a stack trace. Without this, debugging tends…

                                  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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                  • simplify column renaming

                                    We often load ad hoc files with 100+ columns. Renaming those columns is tedious at best. PBI should allow quick renaming of columns in the same way as we do so in Excel, allowing the user to scroll from column to column and just enter the column name in each.

                                    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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Power Query Namespaces

                                      It would be nice to have some kind of namespaces to organize queries and custom functions. bigger data models with different data sources tend to get messy :)

                                      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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Data columns should have an option of being ordered alphabetically

                                        Data columns should have an option of being ordered alphabetically, just like they are ordered under dataset names

                                        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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                        • SharePoint list columns are displayed as internal names

                                          SharePoint list columns are displayed as internal names which do not always match display names in the list

                                          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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 18 19
                                          • Don't see your idea?

                                          Power BI Ideas

                                          Feedback and Knowledge Base

                                          Ready to get started?

                                          Try new features of Power BI today by signing up and learn more about our powerful suite of apps.