Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Easily Scrape All Visible Text from Websites

    It would be cool if Power Query could easily scrape all visible text from website.

    Currently, there is a Website function but it primarily looks for tables and it is hard to extract any text positioned outside tables.

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

    Suggestion: Automatically assign same datatype to a new column which in generated by performing a mathematical operation on 2 or more columns in Power Query.

    Currently, I add a step to change data type for a new column that I am generating after performing mathematical operation on 2 or more columns which have number data type. It would be helpful if Power Query automatically assigns number data type on this new column or if we get an option to choose data type of a new column that we want to add

    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 →
  3. use coordinates as coordinates, dont try to count them

    If you have a longitude in the longitude box and latitude in latitude box, would it not make sense to use them as...coordinates e.g. for a point in which there would be data, say a metric on something? Why would Power BI start COUNTING THEM...oh wait, it does just that!

    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 →
  4. Function applied steps

    In Query Editor, provide the ability to step through the "Applied Steps" of a function. Once a query is turned into a function, it is much too hard to debug a function consisting of multiple steps, when all you can see is the end result of the function.

    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 →
  5. Stop collecting all tables from all databases when not required

    I have noticed that even when just wanting to edit a query, Power BI is collecting lists of tables from every database on the source. On our Impala cluster this is 1000's of tables and views. This is taking time and makes operations within Power BI seem slow.

    Even just trying to create a relationship between two queries, it went and ran show tables on every database before running the describe and select statements that would actually be required.

    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. add date value of M/yyyy

    add date value of M/yyyy

    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. Review and select autodetected relationships

    After selecting to autodetect relationships you should not just be told that X number of relationships were detected, the dialogue should show you the relationships detected and give you the option to use them or not, make them active or not, etc. IN other words you should be provided with a relationship editing window showing just the newly detected relationships.

    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. Add standard control/scroll wheel scaling for database views

    Add standard control/scroll wheel scaling for database views. I have to zoom the database views up to see the details, but cannot seem to do this as I can with Excel.

    -thanks

    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. Excel FREQUENCY() vs. PowerBi Group / Bin

    I see a difference in the results from the Excel FREQUENCY() function vs. PowerBI's Group/Binning feature. Anyway to make it behave like FREQUENCY()?

    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. Add/Access Calculated Columns created in Data View in Query Editor

    I am requesting that calculated columns created in the data view automatically be added to the query editor.

    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. Fix nomenclature of folders and attributes when loading Power BI SSAS Tabular data

    We have the need to load data into Power BI from an SSAS Tabular model in order to capture existing calculations in the model and provide the ability to experiment with new calculations and/or relate cube data (including calculations) to data from an outside source. However- when loading data- If we want each entity to be represented in it's own folder (as we see when connecting live) we found we need to select each entity in the cube using a separate 'Get Data'/ Query. When doing so, the default name of each folder is the CubeName (or CubeName1, CubeName2...) and…

    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. Sort Conditional Column by Order of Conditions

    I created an "Ad Hoc Aging" column (for WIP and AR) with custom ranges: 0-30, 31-60, 61-90, 91-120, > 120. I filled the column with TEXT: Excellent, Good, Fair, Needs Attention, and Alert. Power BI automatically sorts alphabetically. I need it to sort by the order of the conditions.

    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 →
  13. Invoke Custom Function - Required Functionality

    The newly introduced Invoke Custom Functions does not support calculations.

    When calling a Power Query implementation of the Excel PMT Function I need to pass a computation e.g. [Term] * 12 as a parameter.

    fnPMT([Bank Loan], [#"Interest %"], 12, [Term] * 12 )

    The new UI only supports Decimal Number OR Column Name ... what is required is a combination of the two.

    It is now necessary to invoke the Advanced Editor in order to make the necessary adjustment.

    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. "Merge Steps" functionality in Power Query

    I’m often handed scripts that unnecessarily repeat items like "Changed Type", "Reordered Columns", "Renamed Columns" etc...

    It would be great if I could highlight these duplicated steps (Ctrl + left click) and then right click and Merge.

    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 →
  15. 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. Oracle - using tables or sql-statements?

    I'm testing and trying to figure out if I should load the Oracle database tables I need or create sql-statements. I assume, but have little experience that PBI is Limited compared to sql. Any strategical advise?
    For instance, can you solve this in PBI:

    select c.*,a.* from customer c, address a
    where c.id = a.id
    and a.loggdate = (select max(a1.loggdate) from address a1 where a1.id = a.id)

    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. Hotkeys in Syntax window

    Currently Alt+Retun moves down to the next row. There should be an option to set CTRL+Retun as the execute key as syntax is often formatted by bringing text to the next line.
    Using Retun as the execute key causes every change in your code to exectue. Correct functionality should be:CTRL+Return = Execute; Return = New Line;
    There should be an options tab to customize this.

    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 →
  18. Allow Power Query Expression in Filter Dialog Box

    When creating a filter you are not able to enter a Power Query Expression. For example if I am filtering on dates and I want to filter dates greater than or equal to (>=) I cannot enter the expression DateTime.LocalNow() in the filter dialog box. I either have to choose a date from the calendar and then go into the Advanced editor properties of the query and remove the value and enter the expression or write out the entire query in the advanced editor which doesn't make sense for simple filtering scenarios like this.

    Please allow expressions to be entered…

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