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. Improve the Advanced Query Editor

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

    391 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

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

      153 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

        8 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)

        126 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

          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?

          106 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

            under review  ·  14 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.

            94 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

              under review  ·  8 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

              76 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

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

                69 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

                  under review  ·  2 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…

                  53 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 →
                  • 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

                    40 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

                      5 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                    • 35 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 →
                      • 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

                        29 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 →
                        • 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/

                          28 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 →
                          • 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…

                            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

                              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.

                              22 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 →
                              • Average/Count/Sum cells when selecting them in Power Query

                                When in Excel I can select a range of cells and, if they're numeric, will show the following information in the footerbar:
                                Average
                                Count
                                Sum
                                I would find it useful to be able to do the same in Power Query (both when using PQ in Excel and also in PBI Designer). Currently if I select a cell in the results of a PQ query then a box appears at the bottom and shows that selected value (does in PBI Designer anyway, haven't tried this in Excel). That seems like a great waste of what is a rather large box. Why…

                                18 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 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

                                  17 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 →
                                  • 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

                                    17 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 →
                                    • 16 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 →
                                      • 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?

                                        15 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 →
                                        • 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.

                                          12 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 →
                                          ← Previous 1 3 4 5 8 9
                                          • 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.