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 Relationship Drag and Drop Experience

    In Power Pivot for Excel, when you drag and drop columns to create relationships, there experience is:
    1. Click and drag source column
    2. Hover over destination table
    3. The receiving column on the destination table is highlighted to indicate which column will receive the join.

    In Power BI Desktop, item 3 above is missing. It makes it ambiguous how the join will be made (and a poor user experience). Please add a visual confirmation to the user which column will receive the join during drag and drop.

    406 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      4 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
    • Time Zone Conversion Accounting for Daylight Savings Time (DST)

      We need a way to display data in our local timezone accounting for daylight savings time. The data source stores the dates in UTC but we need reports to show local time. A native and easy way to do this in PowerBI would be a huge help. There are many blog posts and help articles floating around with solutions people have attempted but it's a simple issue that so many users would benefit from having solved centrally by PowerBI itself. Please consider!

      112 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        15 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
      • Data Flow Map with Left, Right, Join in Power Query / Power BI

        When joining 2 or more data sets in Power BI / Power Query, a data flow map should be created with the following three scenarios and the total number of records for each scenario:

        1. Left = Records from the Left dataset that did NOT join with records from the Right dataset
        2. Join = Records from the Left dataset that join with records from the Right dataset
        3. Right = Records from the Right dataset that did not join with records from the Left dataset

        6 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
        • Display 'Measure Tables' icon in new Relationship View

          This is a touch pedantic and minor adjustment. In the new relationship view the icons in the 'Fields' section do not indicate if a table is 'Measures Only' or a 'Calculated Table'. It would be helpful if these icons are maintained when looking in the new model view.

          3 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
          • Loading bar (with %) to track the refresh progress in Power BI Desktop

            Add "Loading bar" with % value to track the refresh progress when you click on Refresh All button in Power BI Desktop. Optionally, Add an "Expected Time" of process entire refresh. Or BOTH!

            3 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
            • Parameter e.g. last week

              For a couple of dashboards i want to just go through data-rows of the last week. Is it possible to create a date-parameter that shifts with the actual date? So the report can evaluate only the rows from last week, counting from today.

              2 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
              • Composite Models for Power BI Data Sets

                I often get requests that are derivates of already released reports, but require small tweaks, such as a new dimension to be added to answer. Being able to add composite table to a live data set connection would enable me to more effectively re-use my work, as I wouldn't have to start my project in an already complex pbix file. just a live connection, a look up table an a blank canvas.

                14 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                • Fix the action around Formula.Firewall so instead of a weird error you get prompted with something actionable

                  PowerQuery throws this odd error in some cases when a query references another query. Instead of the error, it should prompt you to select the correct privacy setting.

                  Formula.Firewall without Ignoring Privacy Levels? Query 'x' (step 'Source') references other queries or steps and so may not directly access a data source. Please rebuild this data combination

                  Questions on this come up repeatedly in the forums. See two discussions here:https://social.technet.microsoft.com/Forums/en-US/ee1381f7-c919-4134-be96-5f06dbdb9cd5/how-to-fix-formulafirewall-without-ignoring-privacy-levels-query-x-step-source-references?forum=powerquery

                  And from 2015!
                  https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

                  3 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                  • Always show row count at bottom of Query Editor instead of "999+ rows".

                    Always show row count at bottom of Query Editor instead of 999+ rows. It's something simple that would make life easier when dealing with larger datasets.

                    4 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                    • Give option to copy ALL data when you "Copy entire table" in query editor

                      I sometimes you the PBI query editor to query/aggregate data, and giving a pop-up with an option to copy ALL data, not just the data in memory would be incredibly useful.

                      3 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                      • Power Query "Merge Column" Code That Is Query Folding Friendly

                        Currently in Power Query, clicking on the 'Add Columns' > 'Merge Columns' button and using a custom separator produces M code that is not Query Folding friendly, but it could be:

                        Current:
                        #"Inserted Merged Column Not Query Folding Friendly" = Table.AddColumn(#"Prior Step", "Merged Column", each Text.Combine({[Column1], [Column2]}, " : "), type text),

                        Future:
                        #"Inserted Merged Column That Is Query Folding Friendly"= Table.AddColumn(#"Prior Step", "Merged Column", each [Column1] & " : " & [Column2])

                        2 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                        • choose columns

                          Choose Columns - Automatically selects columns used in the report.

                          We work with Salesforce Data quite often. When I pull a Salesforce Object in, I typically have to use "choose columns to select only the fields I am using, otherwise there is too much data and I'm unable to publish. This process takes a lot of time.

                          2 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                          • Text fields sort differently in Modeling view vs Query view

                            In Modeling, - is before (
                            In Query Editor, ( is before -

                            Please make it consistent.

                            2 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                            • Text to text relationship with trailing spaces

                              We have two tables in which technically they are unique values in the database on both ends.
                              Please notice that one of them have a trailing space.
                              Power BI does not allow me to create a relationship between the two as it does a trim before.

                              Goal is to keep all rows and consider both rows as unique

                              table 1:
                              "AB123 "
                              "AB123"

                              table 2
                              "AB123 "
                              "AB123"

                              2 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                              • Cannot view data error.

                                After refresh data, program found some data errors. I pressed view error button, but program did not go to the error page automatically. So I go to edit queries to check error. Program show me only the header "Query errors and dated" without any data.

                                2 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                • Save CSV via r script run in power query in power bi service

                                  I have an r script to exports a staging query of historical data to CSV. This works fine in power bi desktop. It would be great if this was capable once published. Currently get zero errors, however no export to be found.
                                  I am trying to use this to retain past power bi refresh history as the API is only returning recent results.

                                  2 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                  • R in Power Query without using personal gateway

                                    Currently, Power BI reports with R scripts in Power Query and hosted on service require setup of personal gateway. This is an issue when the developer is on leave and his personal gateway is not online. Requesting support or R scripts in Power Query without use of Personal Gateway (similar to the way R visuals hosted on service dont require personal gateway setup)

                                    2 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                    • When replacing values in query editor, can you make it NOT bounce back to the top of the page. TOO MUCH SCROLLING.

                                      Excel does not bounce me back to the top of the sheet when I replace values from any view of the sheet. Why does power bi? It's annoying.

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Reflect composite models modes in query editor

                                        With composite models enabled, it would be great to be able to switch between the "Import", "Dual" and "Direct Query" while editing the source from Power Query Editor.
                                        At the moment, editing the source step only displays "Import" and "Direct Query".
                                        Sometimes, editing the source query for a table in Direct Query mode, the editor will display import. After validating the query the mode may or may not effectively change the storage mode.
                                        (I couldn't reproduce the issue anymore while posting the idea).

                                        2 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
                                        • stop refresh in data preparation phase

                                          Hi Team,

                                          Is there any way to stop refresh in each and every step in Power Query. During data preparation, if add any step data refreshes from source for all files merged/appended in that query.

                                          We need some feature or button so that once data is downloaded in Power Query, it should not refresh again until we switch on that button. This will enhance the speed in data preparation. Else we have to wait minutes after each is performed. This will help In cases where we cannot see results on small data sets and have to full data even in…

                                          4 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            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 27 28
                                          • 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.