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. Dynamic date slicer

    The new date slicer is awesome, but it would be so nice if you could set a dynamic date selection instead of a static. With a static filter the user will always have to set the dates before the saved report makes sense - especially as the report gets older.

    Dynamic options could be
    YTD, QTD, MTD, WTD, Today, This Year, This Quarter, This Month, This Week and so on.

    800 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

      35 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    • Share Reports in Power BI

      I see that I can share dashboards in the Power BI -- but can I not share reports? The dashboard would be fine, but slicers can't be pinned yet.

      589 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

        81 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →

        We have started work on building this feature so you can share reports with others, much the same way as you can share dashboards today. Thank you to everyone who voted for and commented on this idea. Over the coming months as we design and develop the feature we will use your feedback to shape what we build.

      • Combine enterprise gateway and online data sources

        At this time, a gateway will not function properly if you are using data sources and one is online and one is on-prem. As soon as the online data source is added, the gateway is designed to gray out because Power BI interprets that it is no longer needed. I would like to be able to combine data sources from both on-prem and online sources together with the use of gateways.

        423 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

          54 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →

          Hello everyone,

          We’ve started working on supporting oAuth based connections to go thru the gateways in Power BI which is the main blocker to why you can’t combine today. We’re starting with personal gateway, then will support the enterprise gateway (on-premsies data gateway) shortly after. Thank you for your continuous feedback and passion for this area. Stay tuned, we’re getting close!

          Thanks!
          Dimah
          The gateways team

        • Matrix +/- Collapse/ Expand Buttons

          Please add Collapse/Expand buttons in the Matrix Visualizations. Otherwise when all fields are expanded by default the user would have to scroll a lot to find what they are looking for. I could add a slicer to take user to the data they are looking for but then the rest of the data in the matrix disappears and more specifically the overall totals change!Expand/Collapse buttons would keep the overall totals as intended and totals for other fields while allowing the user to only expand the field they are interested in. Also ability to do conditional formatting for a specific field…

          1,986 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

            152 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →

            Looks like Amanda’s link didn’t work so I wanted to update again. Here’s our documentation on the new preview:
            https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/

            There are a few highly requested features that we know are missing (resizing columns, sorting etc.) and they’re outlined at the bottom of that document .They’ll come in future releases!

            You’ll also see a link right at the bottom of that page to a survey where you can gives us your feedback on what we should prioritize on top of this preview.

            and please do keep commenting here – we read everything even if we can’t reply to them.

            Thanks for the feedback!

          • PowerBI reports and dashboard on-premise hosting

            As per available documentation, power bi reports and dashboards will be published to microsoft cloud. It is very awesome approach as it saves all overhead of maintaining infrastructure. But there are case where on-premise hosting is required, Can we configure on-premise server to host power bi reports just like SSRS reports?

            2,491 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

              309 comments  ·  Licensing  ·  Flag idea as inappropriate…  ·  Admin →

              Hi everyone,

              You can now try the January 2017 Technical Preview: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/01/17/power-bi-reports-in-sql-server-reporting-services-january-2017-technical-preview-now-available/.

              Also:
              - We plan to release a production-ready version in the next SQL Server release wave. (As previously clarified, we won’t be releasing it in a Service Pack, Cumulative Update, or other form of update for SSRS 2016.)
              - We’re targeting availability in mid-2017 for the production-ready version.
              - A few more FAQs in this blog post: https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/12/16/power-bi-reports-in-sql-server-reporting-services-feedback-on-the-technical-preview/.

            • Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

              If I have a date/time field in my data, I should be able to view metrics by year, by month, by day, by day of week, by time of day, and so on. I should be able to drill from month down to day, back up to month, and so on.

              I should also be able to ask for 'last 7 days' or '12 months ago' in my formulas, filters etc.

              I shouldn't need to create a "Date" table and all of these fields in my data. As long as I have a date/time field in my data, I should…

              2,123 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

                108 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                started  ·  Lance DelanoLance Delano responded

                This is started but has quite a few features associated with it. We have previously released the built-in date hierarchies. With the April update we will release a dot notation for using time intelligence with these date hierarchies. This will be under the preview switch for “Inline hierarchy labels.” Turn that on and you will get access to time intelligence functions for these private date tables. Still missing, but on our immediate backlog that we’re working are Nested hierarchy labels, time filters, fixes around how we show time date, and others.

              • Pivot tables and breakdown trees

                The current version of Power BI visualsation framework does not support access to the previous levels in a drill-down. I.e. you only get access to the current level when rendering. That makes it very hard to develop visualizations such as pivot tables or breakdown trees. Make this possible and I would gladly submit a stable version of my Breakdown Trees :).

                2,565 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

                  76 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →

                  We released a preview of a new matrix visual with today Power BI Desktop release. This new matrix can be used as a source of cross-highlighting, has a stepped layout, can be drilled in to /out of hierarchies, and has performance updates.

                  You can read all about it in our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/#matrix

                  During the preview we will be adding even more new features, so keep watch each month for more improvements and let us know in comments what else you’d like to see.

                • Power BI usage statistics

                  Provide analysis of how our Power BI dashboards/reports are being used:

                  Hit count, Q&A queries ran, filters applied, common actions etc.

                  This would allow us to track the importance and use of our reporting and see how different users interact with the data.

                  917 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

                    62 comments  ·  Adoption  ·  Flag idea as inappropriate…  ·  Admin →

                    Hi everyone! Last week, we released usage reporting for IT admins. You can read more about it on our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-service-march-update-part-two/#usage We want to add similar metrics for content creators in the future as well.

                    If you are looking for auditing capabilities (logs of views/export/printing/publishing to web per user or IP) for admins tracking sensitive data or data leaks, please vote on the specific idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13279371

                  • Better Auditing of User Activity (Datasets, Reports, Dashboards, Exports)

                    ALL user activities in Power BI should be logged for auditing purposes, including datasets accessed, reports/dashboards accessed, and especially data exports performed. The audit data should be accessible as a dataset to build reports against as well as easily exportable / downloadable.

                    924 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

                      70 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                    • Custom branding/colour scheme of dashboard (custom css?)

                      How sexy the data looks is sometimes more important than how accurate it is!

                      I love a light grey/dark grey colour scheme as much as the next person, but it be great to be able to brand the dashboard with the organisation colours/background watermark/logos etc. Maybe offer an option to modify the default CSS used - similar to how blogging sites like blogger allow you to change your page layouts/colours with a simple admin gui or completely change it by rewriting the CSS

                      1,586 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

                        79 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
                      • Heat maps in Power View

                        It'd be REALLY nice to have heat maps capabilities in the map visualization of Power View, like those in Power Maps.

                        This is an OFTEN requested feature from our large enterprise customers

                        1,088 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

                          59 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →

                          Hi everyone. We announced a partnership with ESRI to bring their mapping capabilities into Power BI. Their maps include the ability to build heatmaps! The feature’s in Preview at the moment, I’m leaving this marked as ‘Started’ for now and we’d appreciate your feedback. Try it out and let us know how you find it. We’ll update it to ‘Completed’ when we take the Preview label off the feature.

                          More details on the blog: https://powerbi.microsoft.com/en-us/blog/announcing-arcgis-maps-for-power-bi-by-esri-preview/

                          Thanks!

                        • Create different slicers

                          Allow slicers to be created as drop downs, calendars, on/off switches etc. Let slicers contain multiple fields. Also allow user to specify that slicer can only have one value selected and set a default

                          2,159 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

                            123 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                          • Create calculated measures on top of a live SSAS connection

                            Creating a live connection to SSAS MD or Tabular is working just fine. However, it would be very beneficial to have the ability to create new calculated measures (in MDX). Just like we can create our own calculated measures when writing an MDX query for a SSRS dataset.

                            1,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

                              118 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                            • Text wrap in tables, cards, etc.! -- in dashboards and reports.

                              I created an Excel workbook with an XML feed from A.W.rd.A.Day: http://wordsmith.org/awad/rss1.xml. I created a table in PV; text in the description of the word is cut off. I upload to PBI and create a tile. Text in the tile is also cut off. Not cool!

                              1,249 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

                                183 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                              • 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. : )

                                • Allow mailto: hyperlinks in Power BI tables

                                  Currently hyperlinks in tables must begin with www., http:// or https://. Add "mailto:" as an accepted hyperlink prefix.

                                  This would be very helpful for quickly allowing users to see an insight in the data, have the dashboard tell them who the right person to contact would be to address the issue or opportunity, and easily initiate an email to that person.

                                  72 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

                                    6 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Create new dataset from R by doing calculations on data loaded in PowerBI already

                                    The current R data connector forces you to pull data into R directly from the source (CSV, etc.) in order to run calculations and have the results show up as a PowerBI dataset. It would be very useful to be able to do R calculations from data sources already pulled into PowerBI instead, and then create a new data source from those.

                                    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

                                      started  ·  2 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Change X and Y axis labels manually, similar to Excel

                                      I think you should be able to type whatever you want into the X and Y axis to make up the title for them.
                                      This seems like a simple feature and works really well in Excel.

                                      When I have multiple fields in a chart the axis is long and ugly, where a simple edit should be available to shorten this down.

                                      586 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

                                        36 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Support other data sources Direct Query using Gateway on Embedded Power BI

                                        On Embedded Power BI support Enterprise Gateway connection and also support Oracle/HANA and other on-prem databases. This is must for faster customer adoption.

                                        175 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

                                          started  ·  27 comments  ·  APIs and Embedding  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Refresh dashboards tiles when i change a report

                                          It very annoying having to re-draw every dashboard that uses a specific report. It would be nice having automatic refresh of the dashboard tile when I change a report involved.

                                          222 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

                                            28 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
                                            started  ·  loreylorey responded

                                            We’re working on a solution that we believe will solve this problem. Stay tuned.

                                          ← Previous 1 3
                                          • 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.