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.

    39 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 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!

    58 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add a setting to disable column profiling altogether

    There is no way (as of Jun 2019) to fully disable column profiling. The problem is that complex queries can take a long time to execute and the column profiling header bar at the top of each column can take minute or hours of processing to show the color-coded green bar. All the while, it's eating up database resources and making PQ run slower.

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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.

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  5. Skip bad rows at Load stage

    Recently we came with an issue related to wrong formats in data, at Load time if you have bad data you will have an exception and information wont load.
    We need a feature who allows you to skip bad data when you load the information and the option to see rejected records.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  6. Promote selected headers only

    It'd be nice to promote the first row into headers but only for specific columns.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  7. Group/ Binning with Live Connection

    Provide grouping and binning functionality against live data. In particularly against live data from SSAS Tabular data cubes.

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  8. Field formatting multiple data types in a table

    In the field formatting section of a table, allow users to be able to change the data type of the column. Example: I have a custom selected measure that will give the results for both Sales or Units depending the selected slicer choice in a table. I need to have the Sales in currency format and Units in a whole number but cannot have both currently, only one of the other.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.

    22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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!

    167 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

    12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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…

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  13. Enable Search box within the Advanced Editor.

    When in Advanced Editor in the Power Query Editor, if you pressed Ctrl-F a search box would open to help you find text within it.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  14. Export Data From Visualisations as they appear in PowerBI

    It would be good to be able to export data that appears in PowerBi visuals in Excel in the format as they are presented. Currently export will retreive the underlying data and not how it has been pivoted/presented within PowerBI.
    Benefit of this is that the investment in time to get it ini that format is not wasted (or needs more time to redo in excel) if that data is needed for other teams to use

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  16. isnull()

    Please add isnull() to powerquery

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  17. Undo option in 'Applied Steps' in Power Query Editor

    There should be an undo option in case you have accidentally deleted a step in the 'applied steps' section in Power Query Editor.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow for field value alias on data slicer

    In Tableau, you can give a field value an alias, which retains the true, original value. For using something like a binary flag, it helps to have the natural form as 0/1 but on the slicer it can be represented as Yes/No,

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add button to disable full data load on all tables while developing

    We can disable data load 1 query at a time. But if there way limit data load on all tables while developing a report with one click. This would speed up development time

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  20. Have a DisplayAsName at the dataset level for fieldnames so you don't have to rename it all the time for every visual.

    Have a DisplayAsName at the dataset level for fieldnames so you don't have to rename it all the time for every visual. For example if the fieldname is nc_BPS and you want it to show as "Beipiaosaurus" everywhere, it would be nice to have a DisplayAs option.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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 37 38
  • 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.