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. Read Only Access to Relationship View in Thin Workbooks

    My definition of a thin workbook is when you connect Power BI to a tabular server. This can be SSAS Tabular or the Power BI Service (golden dataset as covered here https://exceleratorbi.com.au/new-power-bi-reports-golden-dataset/)

    When you use Power BI Desktop as a thin workbook, you cannot see the relationship view or the data view. While this makes sense (they are not editable), it means that it is very difficult for someone to write local measures. It is not possible to accurately write a local measure unless the relationships between the tables are visible.

    Please add the relationship view so the end…

    101 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
    • Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.

      Through the ability to connect to a Sharepoint Folder, we can connect Power BI to the OneDrive for Business root folder. This is excellent and very important, but insufficient. Most projects require that files be organized in subfolders, to which direct access is not allowed. There are ways to do this, but they are not efficient. I suggest that the solution be enhanced to allow direct access to the subfolders located in the root folder of OneDrive For Business or even Personal OneDrive, just as you can with folders and their subfolders located in Drive C on the desktop or…

      120 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 Sources  ·  Flag idea as inappropriate…  ·  Admin →
      • Stacked Cluster Chart custom visual

        To introduce a Stacked Cluster Chart custom visual combining column and stacked column charts to show side by side this and last year stacked values.

        Business Case:

        1/ Tracking monthly YTD sales and opportunities (in a stacked column) against This Year Annual Plan Sales (as a straight line).
        2/ Comparing monthly YTD sales and opportunities (in a stacked column) to the corresponding YTD sales and opportunity last year (in a stacked column aside to a stacked sales & opportunity column of this month) and Last Year Annual Plan Sales (as a straight line).

        60 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  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
        • Lock placement of tables in relationships pane

          The ability to 'lock' where tables are manually placed on the relationships pane would be very helpful. We have created a data model with security tables, secured dimensions, unsecured dimensions, and secured fact tables. When I lay out the tables in a specific way, the design is far more understandable than when placement is auto-generated. A 'lock' type of functionality to 'freeze' the table layout would be very helpful because I can more easily locate/verify (a) specific types of tables, (b) bidirectional relationships where they should be (and shouldn't be), and (c) relationship directions are accurate.

          197 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

            13 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
          • Breakdown or Weighted Tree

            I was wondering one of a very important visuals missing from Power BI gallery is Breakdown or dependencies tree,
            this will help us to design a good view and give us more room for other visuals to add in our dashboard.

            579 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

              16 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
            • Dynamic row-level security for Power BI Report Server

              Power BI Desktop (optimized for Report Server) allows you to define roles with DAX filters. However, when reports are published to the Report Server, there is no way to assign these roles to specific users/groups, so we can't yet implement row-level security on the Report Server. It would be great it Report Server was able to support dynamic row-level security similar to the Power BI Service.

              591 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

                29 comments  ·  Report Server  ·  Flag idea as inappropriate…  ·  Admin →

                Thanks for your feedback! Here’s a quick update.

                You can implement RLS at a couple of different layers:

                1. Within your data source. Some data sources, such as SQL Server database (2016+) and Analysis Services, have built-in support for RLS. Then, when you connect from Power BI Desktop in DirectQuery mode, you’ll see only the data you’re allowed to see. The same does work in Power BI Report Server if you configure it to delegate (Kerberos Constrained Delegation) or impersonate (“Log in using these credentials, but then try to impersonate…” checkbox) the user viewing the report.

                2. Within your Power BI report. You can define the roles and filters in Power BI Desktop, but can’t yet assign users/groups to these roles in Power BI Report Server. Rest assured we plan to address this gap as soon as we can. We don’t yet have a timeframe to share, but can…

              • Support the conversion of a data source from import to DirectQuery

                Currently it seems that the only way to change a data source from import to DirectQuery in a PowerBI desktop file is using the method found at https://sqldusty.com/2018/01/30/converting-a-power-bi-desktop-file-from-import-to-live-query/ . It would be helpful if there was some supported way of doing this.

                58 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 Sources  ·  Flag idea as inappropriate…  ·  Admin →
                • Allow more than one data source for Direct Queries & SSAS

                  Allow more than one data source for Direct Queries.
                  In order to make Direct query more useful it needs to support data from more than one source & Multiple Cube ,...

                  89 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

                    3 comments  ·  Report Server  ·  Flag idea as inappropriate…  ·  Admin →
                  • Increase the data export row limit (30,000 rows max) in Power BI Report Server

                    The capability to export raw data from Power BI is an important function for many users.

                    Presently, the export data limits are as follows and confirmed at the community link below.

                    - Power BI Service (cloud platform): 150,000 row maximum
                    - Power BI Report Server (on-premise platform): 30,000 row maximum

                    Please increase the export limit setting on Report Server to match that of Service. Better yet, increase them both to a much higher limit as requested by others in separate idea posts.

                    http://community.powerbi.com/t5/Report-Server/What-is-the-Export-data-row-count-limit-for-Power-BI-Report/m-p/343951

                    60 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  ·  Report Server  ·  Flag idea as inappropriate…  ·  Admin →
                    • Latest date as anchor date for relative date slicer

                      Avatar, Alaeddin

                      I hope that you add the ability to add a measure as the anchor date for relative date slicer, it'd be really useful if you wanna set the anchor date as the latest date of your data which can change overtime.

                      74 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

                        5 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
                      • Bookmark groups

                        The new bookmark feature looks great. Would be useful if you could have collections of bookmarks for the presentation mode. For example, we have multiple clients that we provide campaign analysis for. It would be useful to use the same base report for these presentations but with the ability to create a group of bookmarks that are specific to that presentation. That way only one report can be used for every presentation and multiple users could have their own set of bookmarks to view a report in the ways that they specifically care about.

                        302 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

                          under review  ·  5 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                        • Back-button feature to clear selected drillthrough filter value

                          As drillthrough function we use a filter and we give value for it from other report page. I click back-button and it will take me back to where I was before. In the background filter value stays unchanged. I use drillthrough function again. Filter value changes and I see visuals filtered with that value. I use back-button again. I navigate to that report page manually and to my surprice value selected in prev step is still selected. I know that I can open my filter selections and clear selected value but I'd like to do is to start exploring my…

                          419 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

                            9 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                          • Live reference for functionality difference between Cloud Service & Desktop

                            It would be very helpful to have a (frequently updated or "living") specification document revealing the back-end variances between the Desktop and the Cloud Service. This would allow us to proactively plan for errors in the Cloud Service that surprise users because everything worked fine in the Desktop.

                            For example, we recently worked with a Microsoft support engineer on a Dataset that was failing to refresh in the Cloud Service, even though it worked fine in Desktop and at the source. We learned that the cause of the obscure "Not a legal OleAut date” error was due to the code…

                            25 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  ·  Support  ·  Flag idea as inappropriate…  ·  Admin →
                            • copy data to clipboard

                              Copy Data to Clipboard should be a simple right-click context menu capability --- as it has been in Tableau for years. Often, user wants data being displayed without going through export to CSV and import into Excel. Just simple copy-paste of data out of visual to clipboard to ... whatever intended ... is extremely useful.

                              35 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  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
                              • Hide report page and reset drill through filter

                                It would be great to have an option to hide specific report page in normal view, and to make it accessible using the drill-through mode only. Also, the existing drill-through filter option doesn't reset the filters when you leave the filtered page - it'd be great if the page auto resets the filters when the back button is clicked.

                                46 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

                                  6 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                • Disable welcome messages when logging in as free user to Power BI Service

                                  Disable daily appearing welcome messages such as 'You already have an account', 'Almost ready' and 'Invite more people' when free users part of a premium license log in to Power BI Service.

                                  17 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Button that updates datasets and dashboard

                                    We'd like to have a button that you can put on your dashboard in order to trigger a dataset/dashboard refresh. That way we can always work with the latest data.
                                    We have configured the scheduled update but it is not quite working out for us.
                                    Thank you!

                                    17 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  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Disable export of underlying data

                                      We are using SSAS Tabular as our datasource and we have issues when users try to 'Export underlying data' from the Power BI Service. The query generated to SSAS when doing this seems to include every measure from the table which in some cases is 30+ measures and sometimes from multiple tables. The query never completes and consumes nearly all resources on the SSAS server.

                                      We need to disable this option while still allowing export of summarized data.

                                      121 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

                                        16 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                                      • General Tooltip or Infotip for Visuals

                                        It would be cool to have the ability to add Informational Custom Tooltips/Infotips to visuals.

                                        For example, a report curator would be able to add information about what a visual calculates or displays. This could show as a small "i" or "?" that when hovered over, shows a pop over with information about that visual.

                                        This could help users quickly get the most value out of a report and it's containing visuals.

                                        56 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  ·  Adoption  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Email subscriptions for Power BI reports in Report Server

                                          Be able to create email subscriptions for the PBIX reports in the Report Server

                                          931 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

                                            99 comments  ·  Report Server  ·  Flag idea as inappropriate…  ·  Admin →

                                            Thanks for your votes and comments! We’re building out our email subscriptions feature in the Power BI cloud service. For example, today, you can subscribe only yourself to a report, but we’re working on enabling you to subscribe other people as well. There are also some technical barriers to integrating the current implementation into an on-premises server. Once it’s a little further along, it’s something we’d love to bring to Power BI Report Server. For now, consider it on our backlog.

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