Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Allow Determination of Environment

    I would like to obtain Workspace name and when modeling (in M). I would also like to be able to determine whether running locally (Desktop vs Service). About the only environment settings one can currently ascertain are local time and userprincipalname.

    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 →
  2. relationship with wildcards

    Would like to have the functionality that you are able to build a relationship using wild cards, eg:

    Dimension:
    Key: P001Y2GT7777
    Key: P001
    **********

    FACT:
    Key: P0011Y2H22323GT6543

    The relationship to take into consideration the wildcards so that I can classify a line item to multiple times.

    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 →
  3. delete multiple measures

    Allow select and delete several measures at one time.

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

    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 →
  5. 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 →
  6. Execute a Quality Check query before refreshing the dataset

    Provide an option to do a quality check query before refreshing the dataset. This avoids data accuracy to production reports.

    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 →
  7. Option to Record Applied Steps (similar to VBA)

    Data preparation is most time consuming task for an organization. If Power Bi comes with a feature where we can record earlier applied steps and repeat it for recurrent updates in the data, it will be a great use of Power BI. Microsoft can create something similar to what it has done with Excel VBA

    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 →
  8. Excel Formula Functionality (IFS, OR, etc.)

    The scalability for some expression in Excel are way more dynamic than DAX's Version.
    For example, DAX's 'OR' statement can only handle 2 criteria, whereas excel can handle much more.
    Similarly, excel has the 'IFS' statement, which work sort of like 'SWITCH' however, it can handle text as well.

    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 →
  9. Incremental refresh - update report not dataset

    When I want to make changes to a report with incremental refresh, I cannot pull it down from the server. I understand why, as there would potentially be too much data for PBI desktop to handle.
    We have a copy saved on SharePoint, so I would make changes to that and then redeploy. However, at the point of publishing it overwrites the data on the service. The next refresh is then a full refresh. In the meantime, users would not have access to all the data.
    I would like the ability to only make changes to the report, and for…

    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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. email subscription to network drive location

    email subscription to network drive location. shat way individuals can setup a subscription to automatically save data files to a mapped network drive inside of an organization

    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 →
  14. Delay / pause query update while editing

    I would like to be able to stop the automatic update of a query when editing an existing step. This adds a lot of wait time that I’d like to try to save if possible.

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

    9 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. 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 →
  19. 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 →
  20. 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 →
  • 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.