Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. modeling - currency formatting

    I have a difficulty when I have decimal data and need to turn several columns into unit.

    Improvement Ideas:
    1 - Favorite or choose the ones that should be at the top, in my case I have to select column by column and search among so many units that have.

    2 - Select multiple columns and format at once. Ex: Decimals direct to real currency R $.

    3 - Or, formatting princel to replicate this same currency unit format

    3 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 →
  2. 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…

    11 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 →
  3. 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 →
  4. Promote selected headers only

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

    5 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 →
  5. Change "owner" on shared dataset

    For shared and certified datasets, we would like to be able to change the "owner" information to the data steward of the dataset, i.e. the person who certifies and controls access to the data. Currently the "owner" shows up as the person who published the dataset - which isn't appropriate for production datasets that are published by IT.

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

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

    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 →
  8. Allow using Dictionaries in PowerQuery for mapping data

    As a user I would like in Power Query to be able to map/translate/tranform data based on some defined dictionary.
    For example: in source data I have a column "Subcategory" with many combinations. And in some xls file I have mapped those subcategories on new segments.
    There are a lot of combinations (more than 200) so I cannot do it with conditional column. I my opinion quick way to solve this would be by extending "Add condtional column" functionality and add a possibility to load an dictionary from xls in a predefined format.

    3 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 →
  9. Edit PWBI File on RS

    It would be beneficial if the PWBI file could be edited diretly on the RS that live data is available when designing the report

    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 →
  10. Unit conversion in Power Query

    I want to be able to convert units of measurement from one form to another.
    For example: convert kilometers to miles, kilograms to pounds etc.

    1 vote
    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 →
  11. List (and /or Remove) Unused Columns in Data Model

    User built a report with a "Select * ..." query that imported 100's of columns. He used a few dozen columns, spread over many pages. It would be good to have a way to identify all the columns not used anywhere (M, DAX or visualizations) so we can clean up the data model. Idea: gray out unused columns in Power Query, or in Relationships, or Data would help. Better, extend to a list so we can uncheck columns we might use and a button to bulk delete all the checked columns.

    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 →
  12. A connector in PowerBI with which we can directly get data about all the o365 groups, DLs, Security groups in PowerBI

    we can directly get data about all the o365 groups, DLs, Security groups in PowerBI

    1 vote
    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. Parse Options: PHP Serialize

    When you're transforming data in the "GetData" interface, there are parsing options for XML and JSON - very common data formats. A less common format is PHP serialized objects, which are extremely annoying to parse in any system.

    1 vote
    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. Azure Information Protection

    Power BI inherents Azure Information Protection sensitivity labels from Azure SQL and SQL Server.

    1 vote
    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. Create efficient "development mode" for Query Editor query refreshes

    As of August 2019, development of queries with large result sets is painfully slow. It appears this has been a problem for several years. Building power queries is on the critical path and a pre-requisite to data modeling. There also seem to be some defects related to the Power Query implementation in PBI Desktop. Anecdotally, sometimes by cancelling and restarting refreshes, or performing an overlay install of PBI can help queries once "frozen" during a refresh cycle magically return results instantly.

    Ideas to remedy Power Query performance:

    1) Cache the entirety of "base" queries from which others are "referenced".
    2)…

    3 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 →
  16. Visual representation of tables being appended

    When Appending two tables with a lot of columns it would be nice to get a visual representation of the two tables and have Power BI show where columns do and do not match up.

    1 vote
    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 →
  17. Datasets joins can be simplified

    On creating a model, there should be direct option available to specify the join type rather than using the merged queries, which would simplify and promote the PowerBI as self service analytics platform

    1 vote
    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 →
  18. dimension description template

    It would be very useful to add a 'dimension description' page for most used common dimensions. This would complete the dimensional modeling (as by theory) of nominal, ordinal, categorical (etc) dimensions.

    Examples
    - A dimension can have a preferred sort order (by name, by attribute, by measure)
    - A dimension can be numeric, but still ordinal (average and additions not applicable), and the basic interpretation is 'string with numbered sort orders'
    - A dimension can be non-additive (average numbers) or non- multiplicative
    - A dimension can be numeric with labels (e.g. driving distance with road exit names)
    - A dimension…

    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. Apply cross-filters to data in DAX

    Cross-filters only apply to measures. It would be useful to have the ability to apply the current cross-filters to a DAX calculation you can use in columns (and possibly other measures too). The function would probably look something like:

    APPLYCROSSFILTERS(<Table>) returns Table.

    The table returned would be filtered according to the current cross-filters applied.

    Uses would include the ability to have a column in a separate table that depends on the values selected in a cross-filtered table.

    I personally would use it to create a single row table with a column that returns a single SVG that is based on…

    1 vote
    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. Automatically create custom Date tables for all Date fields

    Similar to how a hidden date table is created for every date field in the model by default, there should be ability to define a custom date table that automatically gets associated with all date fields in the model. This will allow model developers to be more productive when there are multiple date fields in the model.

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