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

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

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

        340 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/.

      • Custom Viz access to the previous levels in a drill-down

        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.

        This would let custom viz developers add thing like pivot tables and Breakdown Trees :)

        [This idea was created as an offshoot of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15844186-pivot-tables-and-breakdown-trees. Fredrik had initially asked for updates to the Custom Viz API, but many votes and comments were cast assuming the idea was just asking for the Power BI team to…

        3,070 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

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

          We are working to enable drill down capability for custom visuals as part of the framework.
          This will enable custom visuals developers to declare which of the data roles can be drilled down. the user experience will be the same as it is for core visuals in Power BI.

        • Change column labels/names in the visual

          It would be great if we could change columns labels/names in the standard visuals (Table & Matrixes mainly). In our company we have a data warehouse build to support the PowerBI tabular model with the data. The field names in the data model are not the most intuitive to our PowerBI End User. It could be great if we could change the way the field labels are shown in our tables to be more intuitive and meaningful without needing to change the field names in the data model.

          383 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

            18 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
          • 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.

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

              68 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

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

              512 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

                61 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

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

                991 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

                  74 comments  ·  Reports  ·  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.

                  695 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

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

                  • Improve the Advanced Query Editor

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

                    426 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

                      31 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. : )

                    • Tell me what I can ask

                      When I connect to a new data source and don't really know the structure of the data, I have no idea what questions I can ask. I should get some suggestions or a list of what fields are in the data, etc.

                      54 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  ·  3 comments  ·  Q&A  ·  Flag idea as inappropriate…  ·  Admin →
                      • Enable specific security groups setting for 'Publish to web'

                        The "Publish to web" setting for portal administrators currently has the options of 'Enabled' or 'Disabled'. It would be beneficial to have this manageable in the same way as content packs so certain security (AAD) groups could be set as publishers.

                        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

                          8 comments  ·  Other  ·  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,107 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!

                          • Printing custom visualizations

                            It would be helpful to be able to print custom visualizations to PowerPoint. Currently there is just a message saying that the visualizations are not currently supported. Even allowing the visuals to be frozen in a picture format would be acceptable. Thanks.

                            340 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  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
                            • Need a way to test a dashboard before releasing to production.

                              Need a way to test a dashboard (some sort of a dev environment) before releasing (to production environment). This is especially critical in enterprise settings, where any change to the dashboard will likely have large business impact affecing a large number of people.

                              209 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

                                10 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
                                started  ·  Nick CaldwellNick Caldwell responded

                                We’re doing several improvements to the overall manageability, collaborative authoring, and organization of dashboards/reports. Having a pre-release test environment is a key component of the forward roadmap.

                              • ArcGIS geodatabases

                                Be able to connect to an ESRI ArcGIS geodatabase to view and query on feature classes.

                                231 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

                                  39 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                • Allow Power BI Designer to open a Dataset or Report published in online Power BI repository

                                  If you setup a data source using the Power BI Analysis Services Connector that shows up in the Power BI online Dataset repository you should allow the use of that dataset directly from the Power BI Designer.

                                  This will allow you to publish reports using the already shared dataset and it also gives you a better experience querying a tabular data source then the Power BI Designer does now when connecting directly to the tabular instance.

                                  I would say this should also apply to any other 3rd party data source created there for the likes GitHub, Salesforce, etc.

                                  You should…

                                  231 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

                                    22 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
                                    started  ·  FetiyeFetiye responded

                                    We are currently working on the support to re-open pbix files from desktop.

                                  • 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,867 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

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

                                    • 84 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  ·  Mobile  ·  Flag idea as inappropriate…  ·  Admin →

                                        We are happy to share that the preview of Q&A in now available in the Power BI iOS app. With a unique chat-like experience that’s tailor-made for natural language, you can ask questions of your data and receive answers in the form of charts and graphs directly on your mobile device.
                                        We are eager to hear your feedback, Reply us with your feedback or Join the discussion in the Q&A Discussion on Power BI community.

                                        More details in this blog: https://powerbi.microsoft.com/en-us/blog/now-in-preview-conversational-bi-with-q-a-on-power-bi-mobile-apps-ios/

                                      • 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,642 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

                                          78 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Allow the creation of a Theme Pack

                                          Allow for the creation of a corporate color theme pack. Same principle of styles in Excel: I define a set of styles (colors, fonts, background, format,...) and apply to my report items. For example, let me set the default slicer background color to a suitable shade so that all slicer created start with my default color settings. I would also like to be able to save me color scheme separately so that i can share it with colleagues to create a consistent feel.

                                          863 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

                                            48 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← 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.