Power BI Ideas

How can we improve Power BI?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Bring it to Visual Studio and Roslyn

    Make Roslyn understand Power Query (informally known as "M") Formula language.
    Use visual studio as an editor.
    Get intellisense, refactoring and all other obvious stuff that you need when writing code to work.

    Make it possible to create a Power Query (informally known as "M") Formula project in visual studio, and then compile/package it in a way so it can be used and reused wherever needed.

    Make it possible to write some kind of libraries that you can reference to extend the standard functionality.

    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 →
  2. Ability to convert yyyymmdd Text to Date Values

    Would be realy cool if I can have the ability to automaticaly convert Text in a yyyymmdd form to Date Values.

    At the Moment, I have to prepare a Text Column "zeitwert_aussprache" with values like 20160530 first with a custom column and a formula like

    Text.End([zeitwert_aussprache],2)&"."&Text.Range([zeitwert_aussprache],4,2)&"."&Text.Start([zeitwert_aussprache],4)

    before I can convert it to da date Values like 30.05.2016

    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. Bug in Table/View Sorting

    When I try to sort a Table(right click on a column) in Table/View in power BI Desktop it is showing

    A-Z as descending and Z-A as ascending.

    Its wrong and you should correct it.

    Ascending is A-Z
    Descending is Z-A

    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. 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. Formulación Básica

    Hola! Me gustaría me den una mano. Soy nueva en el mundo de Power BI y ahora mismo tengo una duda que me ocasiona retraso en mi migración. No he descifrado cómo hacer el cálculo de los días laborables y por ende muchas de las visualizaciones que deseo hacer para análisis no son posibles.
    Por favor alguien, ayuda! :)

    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. Use other Date Field to Filter This Date Field

    I have a range of items that have a date attached to them. I also have a start and end date associated with these items. I would like to filter out any of the items that fall outside(either before or after) this date range, and use these two date fields as the criteria. I cannot currently find a way to do this within the Power BI menus. It would be great if I could just select these fields from the filter menu.

    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 →
  7. Add/remove/update measures, datasources, and columns after publishing .pbix file to PowerBI cloud

    I would like to add/remove/update measures, datasources, and columns after publishing the model to PBI cloud. I cannot easily re-upload the PBIX file because there were other reports created off of the dataset than exist in the .pbix file. Also, what if users created their own reports/dashboards based on the dataset. If you remove to upload a new one with the new calcs/measures then you will remove their personalized reports/dashboards.

    This makes it a major hassle to go back and edit the data model of an already uploaded dataset. Allow me to enter PBI designer somehow through the cloud, or…

    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 →
  8. When appended queries automatically add a column to differentiate between the 2 query results

    When you append 2 queries it would be nice to know which rows came from which query after the fact with an additional column identifying them by the query name at the time they were appended.

    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 →
  9. Conditional columns should be able to work with TEXT

    Conditional columns should be able to work with TEXT too and with MORE THAN ONE condition at once.
    This feature is absolutely needed to work with social media and web scraping data analysis.

    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 →
  10. 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. Consistent Folder Query Method XML CSV TXT

    There is no consistent and repeatable method to import folder containing XML or CSV files.

    It is offered as from folder but as we now it doesn't work without wrangling with the creation of various functions in an attempt to get it to work I can list multiple tutorials and all have a different method most which don't work on different sources.

    Can there be an improved and consistent import function that works.

    examples
    http://www.excelguru.ca/blog/2015/02/25/combine-multiple-excel-workbooks-in-power-query/

    https://social.technet.microsoft.com/Forums/en-US/1d31402b-b05a-4091-8ce9-930481c34f93/combine-4-xml-queries-on-same-source-to-be-a-global-folder-query?forum=powerquery#aa1803c9-d86b-47ce-a966-f6a642f40870

    http://www.powerpivotpro.com/2015/01/power-query-for-excel-combine-multiple-files-of-different-file-types/

    http://excelunplugged.com/2015/02/10/get-data-from-folder-in-power-query/

    and all are different

    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 →
  12. New Power Query function to let me know whether a date field falls within a specified range

    I would like a new column function that behaves similarly to the Date.IsInPreviousWeek function, but allow the user to specify what range they would like to see.

    For example, it could be Date.IsInDateRange(beginning number of days before today,ending number of days before today). Then if I entered a new column with the formula of Date.IsInDateRange(1,0) then I would expect the result to be TRUE for any date range that is either yesterday or today.

    This would really enhance the pinned visuals on the dashboard that need to show just today's or yesterday's information.

    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. Visio Integration to document Queries

    I have created a Visio diagram to document the steps in the queries which create the data model. Possibly this could be done as an import to Visio or and Export from Power BI Desktop. Example: http://tinyurl.com/z54ggr7

    10 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. Depascalise headers

    Just a small one - SSAS can automatically normalise pascal case headers. All my data source columns are in PascalCase. I have to rename each individually to insert a space. No big deal but a button to automate that would be a real treat!

    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. Re-size SQL Query Edit Window

    It would be really helpful if the window for editing an exisiting SQL statement could be re-sized. This would make the query editing much easier.

    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 →
  16. Power BI needs a way to show the SQL queries it's invoking

    Power BI needs a way to show you the actual SQL it's executing. It doesn't do this today which makes optimizing the backing indexes and views that Power BI uses much more cumbersome since you don't have any good visibility into what it's actually doing.

    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. Rank/Index for Partition aka Nested Calculation

    It would very useful to have more advanced option for the "Rank/Index" option when preparing the data. Chris Webb came with a possible solution but this should be something that PQ handles in an easier/wizard mode. This is the link of the solution:

    https://blog.crossjoin.co.uk/2015/05/11/nested-calculations-in-power-query/

    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 →
  18. Convert an IP Address to a location

    Would like to be able to get location information (City, Country, Lat, Long) from an IP Address

    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 →
  19. Split Query upon condition

    Sometimes there are csv files containing different data sets, which are separated e.g. with a blank line.

    I know it is possible to duplicate a query, but in Addition we Need an Option to cust first rows by condition. Currently it is only possible to cut rows by number of rows

    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 →
  20. Null values in Text columns

    Blank text rows are still counted in COUNTA and appear as values in charts. The ability to replace "" with a NULL value would allow better, quicker processing.

    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?

Power BI Ideas

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.