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.

    91 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

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

      8 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 →
      • M Code modification (naming steps)

        Query editor suggestion: when we use power query user interface, all steps are named by multiple words with spaces by default, such as "Modified Date", which M code records as #"Modified Date". But if the steps were named without spaces by default, such as ModifiedDate, the M code would be a lot easier to read, follow or modify, since there would be no hashtags or quotes.

        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 →
        • Allow equal key column names in Table.Join

          In Table.Join function we can use same key column names for JoinKind.Inner option, but need to use different column names for other join types, like Left Outer, Right Outer etc. This limitation demand to add excessive steps for renaming duplicate columns before join and removing them after join.
          As Table.Join is much faster and effective than Table.NestedJoin in complex preparation, this seems to be unnecessary and dilatory limitation and should be removed.

          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 →
          • Data sets Wiki

            It will be extremely helpful for users to have a wiki explaining that the data set is for, with business rules and dictionary for the fields, this allowing people not familiar with the set to have a starting point to be able to understand and consume it.

            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 →
            • Staging capability in query editor

              Ability to use queries as temp tables for work/staging and then discard them would be useful.

              E.g. when cleansing data from different sources then appending the queries together, the tables from initial cleansing queries cannot currently be discarded without removing them from final appended table too.

              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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
              • Refresh only new data - not the whole dataset

                We have a large dataset, the refresh takes up to an hour. Sometimes it fails. But, only some of the data is being updated so when we refresh we want to just have the system only refresh the updated data rather than grabbing everything all over again.

                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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                • Memory consumption indicator

                  There should be a way embedded into the Power BI Desktop or to the Power BI Service to figure out the actual uncompressed memory footprint.
                  This doesn't seem to be rocket science, and would save a lot of headache. It would allow analysts to discover how inefficient their data models are. It would ultimately help the Power BI infrastructure as well by helping people to avoid loading the Power BI servers with unnecessary workload.

                  10 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 →
                  • Group measure

                    Allow for separate grouping of measures. Measures could be grouped in their own category instead of within tables. This makes it easier to track measures, specifically when they involve cross-table calculations.

                    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  ·  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 →
                      • multiple data model diagram

                        Provide ability to create different diagram views in relationship designer to manage large# of tables.

                        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 →
                        • Data Visulization

                          When I put some data in to tool tips, and if the data has more then one categorical variables, than it is just showing me first or Last (Not even Both), I want to add that if we can see all the data and variables from the tooltip, than it would be easy to analyze the data. Because data structure of my organization is hard to understand and tooltip helps a lot in to analyze the data.

                          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  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                          • right align values in matrix

                            Would be useful to right align both negative and positive values in 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

                              0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                            • Crypto function group for Get & Transform

                              A big missing feature we'd love to see included here.

                              In Power Query there is no way to authenticate a message using HMAC-SHA256 for example, or simply encrypt a message using MD5, which is extremely common to be needed nowadays that APIs might also require to encrypt parameters in order to accept queries.

                              For this, a M language function group "Crypto", like in most major languages would be just nice.

                              Thanks!

                              Jesus

                              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 →
                              • Allow searching in the "Groups" dialog box

                                I want to create a group on a field that has hundreds of potential options. When you go to the dialog box to define a group, there is no function to search and filter the set of existing records; you have to scroll through every single option. It would be great if we could have a search bar here!

                                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 →
                                • Include MissingField Argument with Table.TransformColumnTypes Function for Power Query

                                  From what I can see (and it's not listed in the M function reference) the built in Table.TransformColumnTypes doesn't accept the MissingField argument like most of the other Table functions. This is extremely troublesome because if you are processing a dynamic data source, columns could come and go. It would also seemingly be beneficial to potentially pull this into the Power Query UI and possibly even set this as the default.

                                  The reason I suggest this is that In most scenarios that I come across, failing to transform a column type is not always something that is "mission critical". Especially…

                                  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 →
                                  • Operations over type time

                                    I am trying to compute the average over time type and it´s just possible to count them
                                    I would like to request to have all operations over time type (average, sum, max, min, etc)

                                    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 →
                                    • Ad a hyperlinks data type

                                      I work with lots of emails and hyperlinks and would love to see this added as a datatype

                                      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 →
                                      • detect gzip format when loading from azure data lake storage

                                        unlike with other file types like json or excel PBI does not detect the binary compression of the file. In result a manual step is needed to work with gzip files from data lake or other file related sources. Please detect gzip and and Binary.Decompress automatically.

                                        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 →
                                        • Data quality bars on data view to show number of NULL or error values in a column

                                          Similar to tools like Alteryx, it would be helpful if a small bar appeared below the column name when viewing tables in data view that indicated the percentage of Null or Error values in that column.

                                          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 14 15
                                          • Don't see your idea?

                                          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.