Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. 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.

    5 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 →
  3. 'Lazy Preview' option in Query Editor when merging / joining queries

    I have a query in which I am joining to another query. The preview need only return a couple of hundred rows. However, the query editor has just spent the last HALF HOUR churning through all 5 million rows in the background, in the multi-gigabyte mashup container (which eats my laptop). I really don't see the need for this! All it has to do is find enough records to create a sufficiently large preview (200 rows will do!) and then STOP. Only when I press Apply should it then attempt to go process everything. Otherwise, I'm subjected to this extremely…

    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 →
  4. Python extend packages

    Currently, python has very limited choice of libraries. Please extend it to be similar to Anaconda. In desktop version, I can use even tkinter to start applications with UI. Or maybe you can give Pro users access in PBI service to install some other libraries. Let's say 5 more on top of what is offered.

    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 →
  5. An option to remove rows that are the same as table headers.

    There are times when the same header line is imported from files multiple times (e.g. when importing a set of CSV files, or when somebody duplicated it in Excel)

    An option to remove rows that are the same as table headers would be both useful and - I think - easy to implement.

    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. I want to make my 3 or 4 row as header rather than 1 row for view purpose

    I want to make my 4th row as a header (just to view purpose), PowerBI has the only option as to use the first row as Header.
    In my data, my first 3 rows have some formulas therefore I cant remove them

    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 →
  7. Tag temporary troubleshooting steps in Power Query Editor

    When the report returns an error of some sort, one might start to filter and apply other temporary steps to the report to identify the errors, and make other temporary steps to find a solution for the errors.
    It's easy to forget those temporary steps you made during the troubleshooting. It would be nice to tag them when you make them for easier identification later, maybe by the right click menu. They could be visualized with another color to the steps or by a symbol next to 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 →
  8. Better Relationship Management

    New tables are placed on the canvas miles away from where they're needed and are slow to drag - fix this by:
    Creating an 'Unlinked tables' panel where new tables sit until they are placed on the page
    Having a hide option for tables in this panel (because some tables, e.g. for Measures never need adding to the canvas)
    It's also hard to see what relationships exist in a complex model.
    Fix this by adding a summary of each relationship to the properties panel visible when you click on a table

    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. Como puedo realizar una resta

    Hola buenos días,

    Tengo mi BD y la columna Concepto y fecha, de ella se requiere realizar una tabla y crear las diferencias por fechas sabiendo que la columna de fechas hay dos o tres fechas y se necesita calcular la diferencia entre las cantidades que existe en el campo de concepto.

    Gracias por su pronta ayuda.

    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 →
  10. Good Morning One idea would be to pass a parameter when the report was loaded, ie a filter already specified for all views when the dashboar

    Good Morning
    One idea would be to pass a parameter when the report was loaded, ie a filter already specified for all views when the dashboard was requested.

    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. join on multiple fields

    I would like support for joining tables on multiple fields i.e. as a composite primary key. Something similar would be useful for table relationships too.

    Currently I have to create a custom column that concatenates 2+ fields and match on that

    7 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. Give ability to "Protect" the link to other step in a step

    No, if I add a new step (s2) below existing (s1), all the other steps referencing s1 change their link to s2. Sometimes it is not ok at all. It would be great to "protect" SOME links from changing, e.g. like it is done in Excel (via using $ in a cell address).

    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. Operations Summary Data in a New Month

    In the 1st week of a new month need to be able to pull from at least previous week or month. As a QV on the 2nd of September only showing a 1 day of data is not useful. If it is there to be able to change time frame please let me know how.

    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. Suffix Support for Data

    Allow the ability to add a string to the end of any numerical data. For example I have a fully expanded hierarchy with two numerical x axis values, I would like to add suffix's to the values without converting them to a string and losing numerical functions.

    This implementation would be similar to the "Units" but with out calculation and a input field for a string, maybe you can even add a factor so people can create custom calculated units rather than creating a measure.

    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. GUI button to create a random sample

    A button/ selection on the query editor or directly in the Filters column that would allow the user to select the option for a random sample. The user could enter how many entries they would like, then a random saple from the data set would filter through to the visualisation.

    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. Export data transformations as rule metadata

    I want to be able to capture the data transformations that are made to a data set as a set of rules. JSON will suffice for now. But ultimately it will need to adopt a rule markup langauge such as one of the standards based approaches used in other frameworks.

    For example, I want to export all column name text relacements in M queries to a list of rules that become metadata about that transformations. In essence it captures lineage and provenance of the data.

    In an ultimate system I would have rules/metadata about a whole host of transforms and…

    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 →
  17. Maintain column locations from query to data

    Once data from a query has been applied, if i then go back and add or rearrange another column in query editor i would like that layout to be maintained when passed to data view.

    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. 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. Allow for column (not measure) value to be determined from a Parameter

    Just recreate the Parameter functionality in Tableau.. where an end user can pick a value from the parameter selection, and have a column update it's value based on the selection.

    Right now you can only change the value of measures by a slicer / what if parameter, and we really need to be able to let users determine the value of columns.

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