Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Make it Easier to calculate variances between two columns in matrix visual table, without having to create multiple measures

    Often we have a summary matrix visual and we just want to do variances between the two now the filters on the table can be quite complex meaning the measures just do the simple calculation of summary matrix column a - b becomes complex due to filter context

    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. Preview downloaded should show time of query refresh, not just time of finish

    I mean it should show the difference between end query time and start query time, and not only time of finishing of downloading the preview.

    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 →
  3. "There's already a relationship between these two columns" - tell me what the relationship is

    When creating a new relationship between two columns sometimes Power BI returns this error - "There's already a relationship between these two columns". Please can you add a feature to tell us what the conflicting relationship is?

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

    14 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. calculation options

    Add "Calculation Options" of "Automatic" and "Manual" like one in Excel.

    12 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 →
  6. 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…

    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 →
  7. Custom sorting in PowerBi service

    Really necessary thing which cannot now in Service version.

    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. 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…)
    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 →
  9. Change Query Parameters using the URL in powerbi.com (master/detail analysis)

    Change query parameters using the URL. Then you can have a Master Report with limited records. And a Detail Report with a Query on a data set with millions of records which is limited by a Query Parameter. Passing the Parameters with the URL can then limit the Detailed data set dynamically. Currently you can only pass filters, which will limit data only after query execution.

    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. News features

    Add an option that allows you to convert the contents of a Table from the Reports View directly to the Data View, instead of using Export to csv.

    Add to the Replace from Query Editor option, replace with a value from another column.

    Add auto increment column in a Report 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 →
  11. News features

    Add an option that allows you to convert the contents of a Table from the Reports View directly to the Data View, instead of using Export to csv.

    Add to the Replace from Query Editor option, replace with a value from another column.

    Add auto increment column in a Report 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 →
  12. Is it possible to perform multiple arithmetoic operation on a single column

    I am able to find hte sum of a column value depend on category but I also want ot divide it by 100. I am not getting this option. Can you please help.

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

    3 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 →
  14. Atan2 like Excel!

    Please can we have ATan2 functionality like Excel!

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

    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 →
  16. 在网页版的数据刷新的时候加上一个暂停刷新的功能

    建议在网页版刷新的时候加上一个暂停刷新功能

    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. Incremental Refresh with Unique Key Column check

    Along with Date Time stamp, there needs to be option to select a Unique/primary Key column too. Else we are only appending data leading to duplication, not checking if a Key was already inserted in the past.

    More Explanation:
    Currently incremental refresh works for the data that was inserted based on DateTime stamp, lets say last 10 days. It does not take into consideration the Primary Key that might have been inserted in the past.
    Eg: Lets say a "Sales Order" was created 3 months ago with a Status "Open", but only today its "Status" was changed from "Open" to…

    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. Add Phone Number as a data type or category

    Adding a phone number as a data type or category so that Power BI can easily interact and manipulate phone numbers into different display formats

    Ex:
    (123)-456-7890
    (123) - 456 - 7890
    123.456.7890
    1234567890

    And treat all the same so that if a user searches using one of those formats, no matter how the data is actually stored that it can find anyone of them.

    Could also map the area code to geographical locations too

    4 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 →
  19. Half yearly growth

    Similar to QOQ, YOY, MOM growth, It would be helpful to compare 6 months growth

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

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