Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. See relationships in table colums headers

    Hi, it would be great to see if a column in the table view haves or not a Relationship.
    For the moment, "manage relationships" is cool but helpless to find missing relationships in a table for large data models.

    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 →
  2. Add anotations capibilitiy to data models in Power BI or Power Pivot

    Add annotations capability to data models in Power BI or Power Pivot just like in SSMS data diagrams to facilitate model documentation.

    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 →
  3. Mouseover Tooltip for Tables names

    Hi guys. Im working with several tables (facebook insights) and each one of the tables has some lines for its description. I added the descriptions within the Query Editor by right clicking the Query Table, selecting Properties and filling the Description's textbox.

    But, when I am working with those tables within the Report view, and I mouseover one of the tables name, it does not show the descriptions, but just the table or query name. It would be very very useful (in this case, I am working with 40 tables) if it could show us the description of the 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 →
  4. ID data type

    An option to import a column as an ID column which does not automatically sum like an integer but is sorted as an integer and not like a string.

    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. Easy NULL button in Query View

    I'm exploring databases we've not explored before and have found myself looking at a lot of tables and columns that have "Null" for the entire column.
    I would LOVE to have an "Easy NULL" button that basically tells me: here is a listing of all the tables, and the columns, where the only value found in the columns were NULL values...and then have a "Remove Columns from Query" button....and that's it...all removed. The problem right now is that when you KNOW what you want, it's not an issue...but when you are exploring new databases you have to go through each…

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

    Please add geocoding as a feature. It would be awesome to be able to add a longitude and lattitude column based on adress columns in the 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

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add a pre-filter/query for reports that point to live data

    Enable query for reports/dashboards that point to live data (Power BI Service dataset). I need to filter live data before it enters a report.

    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 →
  9. Allow Hierarchies to be created from multiple tables

    Currently to create a hierarchy from multiple tables you have to manually add the fields to the Row context of a visualisation. If, therefore, you want to use this "hierarchy" in multiple visualisations you need to duplicate it over and over (or copy and past the visualisation and amend it). By allowing multiple table hierarchies, you would be more easily able to use hierarchies in multiple reports/visualisations.

    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. Arreglos al catalogo de regiones

    El catálogo de regiones para México esta mal. Anexo catálogo corregido.

    id. abreviatura iso nombre nombre (español) código postal
    mx-agu Ags. MX-AGU Aguascalientes Aguascalientes AG
    mx-bcn B.C. MX-BCN Baja California Baja California BN
    mx-bcs B.C.S. MX-BCS Baja California Sur Baja California Sur BS
    mx-cam Camp. MX-CAMP Campeche Campeche CM
    mx-chp Chis. MX-CHP Chiapas Chiapas CP
    mx-chh Chih. MX-CHH Chihuahua Chihuahua CH
    mx-dif CDMX. MX-DIF Ciudad de México Ciudad de México DF
    mx-coa Coah. MX-COA Coahuila Coahuila CA
    mx-col Col. MX-COL Colima Colima CL
    mx-dur Dgo. MX-DUR Durango Durango DU
    mx-gua Gto. MX-GUA Guanajuato Guanajuato GT
    mx-gro Gro. MX-GRO Guerrero Guerrero…

    1 vote
    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 →
  11. excel We couldn't find any data formatted as a table

    It would be very helpful to connect to a excel file not formatted as a table as you can in the desktop version.

    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 →
  12. group by "other columns" in Query editor

    Add this feature to "Group By":
    allow option to group by "other columns" similar to unpivot other columns or similar to remove other columns.

    when dealing with a lot of columns this would be helpful. If I could just select the columns I don't want to group by then select "group by other columns", this would be awesome!

    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. filter out rows that match headers

    With the combine binaries, it would be nice to have the ability to automatically filter rows that match the headers as these are obviously the headers of subsequent files.

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

    It would be amazing if other than XML and JSON, there would be another data transformation type: QueryString, that would automatically split the values in various columns.

    Example, from:
    http://aaa.com/bbb/ccc?title1=value1&title2=value2&locale=1234
    http://aaa.com/bbb/ccc?title1=value3&title2=value4&locale=567

    To columns (and relative headers):
    baseUri title1 title2 locale
    http://aaa.com/bbb/ccc value1 value2 1234
    http://aaa.com/bbb/ccc value3 value4 567

    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. Easily calculate DAU/MAU

    if you have a table containing:
    UserID, EventDate

    is not straightforward to create a Retention Graph, like DAU / MAU (Daily Active Users divided by Monthly Active Users).
    Please make easy (or explain with detailed examples) how to create those kind of graphs.

    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. There should be dynamic FILTER

    There should be dynamic FILTER that catch up the slicer values and on this way we can calculate running average value on the correct dataset

    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 →
  17. Power Query - M Code for unspecified number of columns

    When creating Power Query steps that create new columns the M code generated is for a specific number of columns. There should be an option so that the M code works for a variable number of columns.

    An example of what happens when splitting by delimiter is at the bottom of the suggestion.

    Clearly this code will fail if the source data is updated and has anything other than 34 columns. The same is the case for other transformations such as expansion of columns.

    #"Split Column by Delimiter" = Table.SplitColumn(#"Removed Other Columns","Text",Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv),{"Text.1", "Text.2", "Text.3", "Text.4", "Text.5", "Text.6", "Text.7",…

    1 vote
    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 →
  18. Loading fibnancial data

    Hi

    I am trying to build a data model that will compare the Financial statements(BS,P&L) of public companies.

    Could you please suggest any best practice to do so.

    I tried unpivoting the traditional financial statement but writing ratio measures seemed not possible or clear.

    Thanks

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

    Hello,

    Thank you for this great tool! This has definitely aided me in managing my customer accounts better. one suggestion That I have and NEED, is the ability to create a graph that will allow times to report based on 15, 30, 45, 1 hour increments. example. if my account is receiving excessive activity. I want to be able to create a table (the way I would in excel using the =mround(b2, "0:15")) and then put the information into a graph that will show me the times the alarms are coming in. at this time, that's probably the only thing…

    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 →
  20. Boton Deshacer

    Agregar un botón para deshacer.

    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.