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. Custom Territory for Power BI Map.

    It should be possible to create a custom territory in Power BI. Not every Organization uses Continent, Country, State & Province or County for Mapping. Some Organizations want to create customer sales territories which is hugely valuable in getting granular into your Data.

    Currently this feature is available in Tableau.
    http://powertoolsfortableau.com/tools/drawing-tool

    This will also eliminate the use of Location Intelligence software as a counterpart when analyzing data.

    240 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

      11 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
    • Allow us to have a global option to disable the automatic detection of column types

      Please allow us to disable the feature "Automatically detect column types and headers for unstructured sources" from Options --> Global, and not only from Options --> Current Workbook.

      Read here about the rationale for this request: http://datachant.com/2017/01/11/10-common-mistakes-powerbi-powerquery-pitfall-2/

      28 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
      • Show/Not Show Subtotals

        I would like to be able to choose whether or not i want to see subtotals in a table or matrix, to be able to turn them on or off. I know you can do this with totals under general but sometimes i want the grand total but not subtotals.

        14 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          1 comment  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
        • support for ArcGIS embedded visual

          Can you add support for ArcGIS embedded visual?

          32 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  APIs and Embedding  ·  Flag idea as inappropriate…  ·  Admin →
          • Power BI Embedded Parallel Query Submission

            Allow developers to specify how many concurrent queries should be submitted by a single Power BI Embedded report.

            Backgrround: If a report relies on several independent direct queries, the Power BI Embedded server throttles their submission to the data source. This prevents the report from using the full power of the data source.

            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

              0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
            • Introduce "Make table" function to Power BI

              This is for the "Edit Queries" view. MS Access has the "Make table" query function. For example if you have a source file with 1 million lines but you can filter them down to 300k, you can have the query create a new table and copy the values of those 300k lines into that new table. With subsequent queries you don't have to reference the 1-million-source file but you can now reference to the vastly smaller 300k-table, which makes further data processing much faster.

              8 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
              • Introduce a powerful export function

                Right now, Power BI can only export data from the report view to CSV. I would like to be able to export from the "Edit Queries" view to different formats, like CSV, Excel, Access DB, XML, Sharepoint, HTML, etc.

                8 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Analytics  ·  Flag idea as inappropriate…  ·  Admin →
                • Conditional Formatting based on a different measure

                  I would like to be able to format a column in a table or matrix based on values of a different measure, or based on values of the same measure in a different row of the table.
                  Examples :
                  1. Conditional formatting of sales amount based on the value of sales amount last month(green if higher, red if lower etc.).
                  2. Conditional formatting of sales amount based on sales goal(higher/lower than goal, and how far from target)

                  56 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

                    3 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                  • identify power bi pro content

                    Whenever Power BI warns that "this dashboard has Power BI Pro content", provide a link to describe specifically what Pro content is included in the dashboard. For example, is it pro content because it's in a group workspace, or is it pro content because it's a direct query connection to an on-premise data source, etc.

                    7 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Licensing  ·  Flag idea as inappropriate…  ·  Admin →
                    • Mac Friendly Desktop Version?

                      Is anyone else wishing for a Mac OS version?

                      16 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        4 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                      • Improve Querying performance to SQL Sever Analysis Services with large data

                        Especially Tabular Models with large volume suffer from the quality of MDX generated by PowerQuery component. For example, the same queries made in Excel Pivottable are most of the time faster with a better MDX generation. Also, why not querying tabular models with DAX ! previewing queries with a subset are very slow in case of use of high cardinality attributes

                        14 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
                        • Change font family on titles and column headers

                          Regarding some corporate branding practices it would be very useful to be able to change font family of title and column headers in reports.

                          Is there any plan to achieve this in a next release?

                          36 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
                          • AtScale connector

                            My client intends to use AtScale as an OLAP semantic layer for a data lake. The ideal use-case would be to have Direct Connect capability to the AtScale cubes. Would be great to see a connector for this platform.

                            7 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              4 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
                            • Support refresh from the web when running code/script (Power Query, SQL, R...) from a text file

                              When you deploy multiple dashboards that use the same script/code (whether it data transformation in Power Query (M), a SQL statement or an R code), it is efficient to put one code in a text file, and query against the file, rather then copy/pasting the code every time you make a change.

                              Here is an example of a workaround: https://blog.crossjoin.co.uk/2014/02/04/loading-power-query-m-code-from-text-files/

                              The problem is that now you can't schedule a refresh from the web: Power BI throws an error
                              "You can't schedule refresh for this dataset because one or more sources currently don't support refresh."

                              Can you make such approach acceptable…

                              10 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                2 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add Legend on Table View and Matrix View

                                Allow adding legend to table view and matrix view. The legend could be a dimension, calculated columns, or a measure. For dimensions and calculated columns, allow discrete colors. For measures, allow gradient colors.

                                18 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
                                • Make it possible to give more than 1 vote to the same idea (again).

                                  I really liked the old voting system where you could give three votes to the same suggestion in the Power BI forum. In fact, I think it was perfect. The new system just doesn't give the same feeling of actually being able to impact the way Power BI is evolving.

                                  8 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Slider / Slicer for Values

                                    We now have a great Slicer for dates, which is presented as a Slider, but it would be great to have a similar Slider Slicer for values too.

                                    eg, If I have a field called 'Customer Balance' and want to give the end user the ability to filter down between two values (Customer Balances between 1000 & 10000), then a standard Slicer is not suitable as it just lists the balances. A Slider based Slicer will fill this role.

                                    44 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      5 comments  ·  Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Datset as a Data Source

                                      Add the ability to consume a Dataset from PowerBI service via the Desktop. This would allow reports to be built using the Desktop vs having to login to the Service, but mostly it allows centralization of Data etc.

                                      Other features this would provide is the ability to add calcs and join other data with a Dataset or join multiple Datasets together.

                                      This relates to the following other ideas:

                                      https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7093112-updatable-pbix-xlsx-datasets

                                      https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13478433-dataset-desktop

                                      https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11081736-avoid-redundancy-of-datasets-same-source-2-data

                                      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

                                        0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Redshift Connector in Power BI Service and Data Gateway

                                        Redshift Connector in Power BI Service and Data Gateway really needs to be available soon. Although the release in July enabled Redshift as a Data Source in Power BI Desktop, there is still no update on when this will work in Power BI Service. We now have a strong need to allow for this connection to work in Power BI Service. This must work in Direct Query mode. In addition we should be able to Import Data into the Model and use Data Gateway to Refresh in Power BI Service. That way we can take advantage of the DAX functionality. …

                                        45 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          2 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Conditional Formatting - Whole Table Rows

                                          It would be great to be able to format full rows and not just specific columns in tables.

                                          For example - I have a list of date driven tasks and would like to highlight the entire row where the task is overdue.

                                          10 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

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