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. Export Column Profiles as a Table

    my customers love the new column profiling feature in Power Query. With the GA today, it is even better. One thing I have been asked for a few times now is the ability to export the column profile data as the result of a query. Ideally this could be exported to Excel for further investigation, or simply return it to ta table in Power BI for further investigation.

    34 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  2. Stop Executing Queries Multiple Times

    I create a query in Power BI Desktop against a data source. Power BI Desktop insists on executing it multiple (usually three) times. This makes Desktop slow and for back-end data sources exerts additional load that can also incur additional costs.

    Note: I am not talking about the scenario where a query is referred to multiple times in M, rather just a simple query loaded into one table in the data model. I assume the engine is checking data types, etc - but the current approach is very slow/painful. Optimisation is needed!

    25 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    154 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    16 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  4. Make code generated by Power Query UI less dependent on hardcoded values

    All the code generated using the Power Query UI is so literal, it feels like I'm interacting with a dumb kid. If I'm selecting all columns and, say, trimming them, why hard code all the column names? It makes code hard to re-use and brittle, which generates a lot of menial code editing overhead.

    Instead I would like PQ to try and generate more generic code. I'm sure combining soft coding with code generation is a hard problem, but this would have so much more impact on the productivity of Power Query developers than sinking resources into yet another sentiment…

    7 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  5. Incremental data refresh from a stored procedure

    Incremental refresh works good when refreshing data from tables. We have to deal with complex logic and predefined structure which is not possible from tables. Incremental refresh from stored procedure will be very helpful.

    7 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  6. Rename query steps without refreshing preview

    While renaming query steps (right-click rename OR right-click properties) when you apply the name change, it will re-run the query step. Why? Best practice to rename query steps yet for very large data sets this becomes cumbersome during the queries initial development. Note: I could be missing something valuable that would prevent this, please advise.

    8 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  7. Disable "see records"

    There should be an option to disable "see records" for the graphics that support it. It is a huge issue when it comes to security. I know you can hide certain columns but in reports that should only be high level data, the see records item is really an issue.

    13 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  8. Quickly remove all columns containing only Null/Blank values

    The recently introduced Column Quality feature in the Query Editor allows us to identify Valid, Error and Empty values in each column.

    It would be great if we could quickly and easily remove all columns that only contain Null/Blank values.

    I recently had a situation where I'd loaded a table containing 100 or so columns into the Query Editor and I had to manually work through these removing all such columns - which was at least half of them.

    Having such a feature avaialble in the Query Editor wold be fantastic, and it may also be useful to have something…

    6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  9. Change data types and other formatting functionality with SAP HANA DirectQuery

    The SAP HANA DirectQuery does not support data prep features like changing data types as well as other formatting changes. Without the ability to prep the SAP HANA data with DirectQuery, there is no way to leverage SAP HANA's real-time data capability. Thus, whenever a user needs to change data, they are forced to use Import (a static data set).

    8 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  10. Edit Data Table From Relationship View window

    In the current relationship view window we can delete a data table from the model.

    It would be nice to right click on the data table and click edit query for the underlying table. This would immediately open up the query editor for data table changes.

    Today you have to switch views to the table view, and click edit table. or navigate to the edit queries button and click edit queries. Doing this opens the queries, but you still have to navigate to the table you want to change.

    3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  11. Identify missing join values

    Recently some Column Quality and Column Distribution checks have been introduced into the Query Editor, which are great.

    A useful addition would be identifying Foreign Key values for which there's no corresponding Primary Key. A simple and common example of this would be identifying Customers who appear in the Sales fact table who don't appear in the Customer dimension table.

    The join created by the developer would identify the Foreign/Primary Key relationship, and perhaps any such orphaned Fact table records could be highlighted against the join itself.

    Currently such occurrences of this will usually result in Sales values posted against…

    6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

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

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

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

    10 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  13. Query mode QoL: Add name of new column in applied steps

    Instead of using the generic "Added Custom" or "Added Conditional Column", rather insert the column name to make it easier to navigate through the step logic.

    For example if I add a conditional column called Turnaround time, it is far more useful for me to see that I added Turnaround time than for me to see what type of column I added.

    It saves time that is waste having to manually rename those steps and also means that if one of my colleagues works on the model, they can easily identify important items without having to go through every addition…

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  14. Permite mostrar conceptos de diferentes categorías en filas

    Mi empresa es de supermercados, Seria ideal que BI permita mostrar conceptos de diferentes categorias en filas y que en columnas muestre semana,mes,trimestre, año. Imaginar montar un presupuesto de una empresa en esa vista, tipo FORECAST 1,FORECAST 2,FORECAST 3,FORECAST 4, donde por filas muestre, ventas, margen, %msv,% de las perdidas, cifra de las perdidas conocidad y desconocidas,el grupo de un balance perdidas y ganancias, % el ratio de gasto de personal,el ratio de rotacion de personas de rrhh,las secciones de carnicerias, charcuterias,fruterias, o a nivel sector agrupado,

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  15. Ability to link dashboards and reports from one app to another

    Create the ability to link dashboards and reports from different apps to another app and see the most up to date dashboard/report version on both apps.

    For example, a group may want centralize to a single app for all of its users to view:
    3 dashboards and 1 report from App 1
    1 out of 5 dashboards from App 2 
    2 out of 7 dashboards from App 3 
    along with adding 4 additional dashboards of its own

    To my current knowledge, dashboard and report sharing can be done in a few ways:
    Those dashboards have to be saved to multiple…

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  16. Create and Enum data type

    Currently it is possible to create calculated columns in DAX as well as to add columns through Power Query. But for every column we add, our models get more bloated while the user interface gets more cluttered.

    I propose the addition of an enumeration type that is only evaluated at run time, this would reduce the file size of models by only requiring the developer to store references to values once. It would make possible to handle translation of the value in a secondary lookup table, thus eliminating the need for a complete re-evaluation of the column every time the…

    3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  17. COUNTIF in DAX Language

    A COUNTIF is sorely missed in DAX.

    (The workaround with CALCULATE and FILTER is too cumbersome and complex for most users)

    5 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  18. Text wrap the display within Advanced Editor

    Text wrapping on a line-by-line basis within Advanced Editor. Currently you have to manually enter a carriage return and tab it over to format.

    4 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  19. Composite Models for Power BI Data Sets

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

    18 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  20. Save CSV via r script run in power query in power bi service

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

    8 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 34 35
  • 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.