Power BI Ideas

How can we improve Power BI?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(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. Improve the Advanced Query Editor

    Add better static analysis, IntelliSense, and general formatting abilities (like allowing tabs) in the "Advanced" editor

    885 votes
    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)
      You have left! (?) (thinking…)
      27 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →

      We’re actively working on adding IntelliSense support for M authoring in the Advanced Query Editor, Formula Bar and Custom Column dialog. Expect to see these capabilities in one of our next few monthly updates, hopefully before the end of 2016. : )

    • Regular Expressions support in Power Query

      We think regexp support will help the adoption of the Power Query tool in the most demanding use cases. Many thanks.

      382 votes
      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)
        You have left! (?) (thinking…)
        9 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
      • Support relative path to excel/csv sources

        Currently, when excel file is loaded to Power BI, the absolute filepath is captured in the M query. It would be nice if relative filepath was supported. Thus we could place excel file next to pbix and not worry about the file location (local machine, shared folder on server or onedrive)

        277 votes
        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)
          You have left! (?) (thinking…)
          8 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
        • Fuzzy Comparison function for similar names

          For either a Power Query function or a new DAX function, we could use a fuzzy string compare to provide a score like 1 to 10 of the similarity of a string. I believe that SSIS has some functionality like this. For example we often has Company Names that we need to match to an external source and would like to get a score to compare names like "Wal-Mart", "WalMart","Wal*Mart", "Division or Wal*Mart", "Wal-Mart Stroes", etc. Does anyone else need this type of compare - or found a simple way to do it in Power Query?

          237 votes
          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)
            You have left! (?) (thinking…)
            under review  ·  13 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
          • SAP BW display Key and Text

            It seems as if only Text is available to select.
            We require the Key to be available to build relationships and to view data

            195 votes
            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)
              You have left! (?) (thinking…)
              7 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
            • Ability to use wildcards in power query transformation find section of replace values.

              In the transformation area of replace values it would be nice to be able to use a wildcard in the value to replace field. For example we have transaction descriptions like... Placement [EB-12375596] and it would be great to be able to enter something like... Placement% to capture all of these. I've got several work-arounds but this would be a great feature for those who don't know SQL.

              180 votes
              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)
                You have left! (?) (thinking…)
                under review  ·  8 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
              • Convert Power Query transformations into SSIS (ETL) and also SQL Server stored procs

                Imagine using the capabilities of SSIS or plain SQL Server and/or to execute Power Query transformations at high speeds. I see Power BI Designer as the transformations editor + small data transformation tool and SSIS/SQL as the big data transformation tool.

                127 votes
                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)
                  You have left! (?) (thinking…)
                  under review  ·  2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                • Discard Query Changes

                  The query editor only has two options "Apply Now", and "Apply Later". What if I've messed up my query and never want to apply the changes?

                  Please bring back the ability to discard changes made during the time the query editor was open

                  80 votes
                  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)
                    You have left! (?) (thinking…)
                    5 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                  • When we add Custom Column, allow us to choose its position

                    When we add a new column in the Query Editor, it always places the column at the end. This makes it difficult to visualy relate the new column with the other columns that were used in the calculation, and make if difficult to debug our custom column code. The workaround to use ordering after we add the column, is not user friendly if we have dozens of columns.

                    It would be helpful, if we can choose the location of the column from the UI (with a default), and that you add a fourth optional parameter in Table.AddColumn for the column…

                    64 votes
                    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)
                      You have left! (?) (thinking…)
                      1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                    • 51 votes
                      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)
                        You have left! (?) (thinking…)
                        4 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                      • Using git or some other SCCS to store M queries (NOT a data source)

                        Power Query M queries are code and can benefit from a source code control system like Git for:
                        1. sharing
                        2. versioning
                        3. backup

                        It would be great if you could hit a button and either import or export a query to git or svn and whatever is the Visual Studio equivalent

                        51 votes
                        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)
                          You have left! (?) (thinking…)
                          2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                        • Allow us to have a global option to disable the automatic detection of column types

                          Please allow us to disable the feature "Automatically detect column types and headers for unstructured sources" from Options --> Global, and not only from Options --> Current Workbook.

                          Read here about the rationale for this request: http://datachant.com/2017/01/11/10-common-mistakes-powerbi-powerquery-pitfall-2/

                          47 votes
                          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)
                            You have left! (?) (thinking…)
                            0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                          • Make "combine binaries" independent from existence of a particular file

                            Since the November 2016 upgrade of Power BI Desktop, the "combine binaries" functionality is strongly improved.
                            However, I have 1 suggestion for improvement already.
                            The "combine binaries" functionality creates some objects, including a query "Sample Binary".
                            This query returns the first file from the (selected) files in the folder.
                            Unfortunately, the name and path of this file are hardcoded, e.g. from the advanced editor:
                            #"C:\Users\Marcel\OneDrive - Bemint\Office 365\Power Query\DateTimeTables\_(UTC+0000) Casablanca xlsx" = Source{[#"Folder Path"="C:\Users\Marcel\OneDrive - Bemint\Office 365\Power Query\DateTimeTables\",Name="(UTC+0000) Casablanca.xlsx"]}[Content]

                            Consequently, when that file would be removed from the folder, you would get errors when refreshing this query.

                            So my suggestion…

                            42 votes
                            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)
                              You have left! (?) (thinking…)
                              0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                            • Power Query Libraries and Extensibility

                              Allow connecting to / sharing of M functions and libraries. For example, I've been keeping a set of useful "utility" functions here: https://github.com/tnclark8012/power-query-extentions/blob/master/power-query-extensions.m

                              It would be great if I could share or import them in a convenient way, and perhaps reference them without the table syntax.

                              38 votes
                              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)
                                You have left! (?) (thinking…)
                                1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                              • PowerQuery - UI option to temporarily suspend a step

                                In Powerquery, when I want to temporarily remove a step, I can either:
                                1. Delete the step, then test without it, then recreate it
                                Or
                                2. Manually modify he M code by putting // and then resetting the names manually.

                                I would appreciate a quick way to suspend a step in the UI - something like there is in vba

                                37 votes
                                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)
                                  You have left! (?) (thinking…)
                                  2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                • Add a way to find or jump to column in query view

                                  It's very difficult to locate columns when a query has many of them. Add functionality to search for or jump to a a column in query view

                                  23 votes
                                  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)
                                    You have left! (?) (thinking…)
                                    2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Fix Power Query Glitch for Loaded Tables

                                    When loading Power Query as a table into Excel you can add formula to adjacent columns and they will copy down automatically. However when refreshed the formula does not copy down correctly unless you change Table Properties to Preserve Column Sort / Filter Layout

                                    https://www.linkedin.com/pulse/dont-get-caught-power-query-trap-wyn-hopkins

                                    22 votes
                                    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)
                                      You have left! (?) (thinking…)
                                      2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Enable Excel when Power Query Editor is Opened

                                      When the Power Query Editor is opened I am unable to navigate any Excel spreadsheets unless I open a new instance of Excel altogether.

                                      21 votes
                                      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)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Return multiple tables from a single query

                                        I'd like a way to return multiple tables from a single M query (maybe by returning a list of tables and telling Power BI to automatically create one query for each table in the list). My specific scenario is that I'm working on a content pack for an online service, and in the data model a single fact table will have a varying number of dimension tables associated with it depending on the customer. I guess this could also be useful in other scenarios, for example where a stored procedure returns multiple tables.

                                        20 votes
                                        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)
                                          You have left! (?) (thinking…)
                                          1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                        • recognize January text as a date

                                          Hello,

                                          I have my data loaded into scenarios (Budget, Current Forecast, Prior Year, etc.) by month (January - December). I don't want a specific year associated with those months because the Scenario tells you what year you are looking at.

                                          However Power BI doesn't recognize it as a date so when I put it into a graph or something it organizes the data alphabetically.

                                          Can you please change it so it knows this is a month?

                                          18 votes
                                          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)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6 7 8
                                          • 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.