Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Function to calculate working / business days between 2 dates

    Can we have a function similar to Networkdays in excel to determine the net working days between 2 dates. for the list of holiday which will be optional, we can enable it via list or separate table.

    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. Option to Disable and Define Calculated Columns and Table Execution Order

    When complex calculated columns or tables are added to the report of a large dataset, the execution order matters especially when refresh the report with new data range. It leads to not enough memory issue when the Power BI refreshes the queries and the dax calculated columns or tables at the same time.

    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. Unit conversion in Power Query

    I want to be able to convert units of measurement from one form to another.
    For example: convert kilometers to miles, kilograms to pounds etc.

    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. 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 →
  5. Excel table with the total line

    Hello,
    If an Excel table has a total row, this table will be imported with the total row in Power BI as an ordinary row.
    Adding this row will cause mistakes in the PBI report and I suppose that the majority of users don't need it in their models.
    I suggest to ignore this row when we import an Excel table in Power BI and Power Query.
    More explanation can be found in the link below:

    https://numidiabi.wordpress.com/2019/07/29/power-bi-power-query-import-table-with-total-line-big-mistake/

    Thank you

    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 →
  6. Input Excel's [h]:mm:ss format in Power BI

    To allow easy calulation of time over 24hrs

    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. A connector in PowerBI with which we can directly get data about all the o365 groups, DLs, Security groups in PowerBI

    we can directly get data about all the o365 groups, DLs, Security groups in PowerBI

    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. Distinct Count summarization in Manage Aggregations

    When defining aggregate tables using the "Manage aggregations" dialog, there is no option for mapping an aggregated column as the distinct count of a column in the source table.

    This causes all DAX queries using DISTINCTCOUNT to use the source table instead of using the aggregated table. In order to improve performance, we'd like this option to be added.

    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. Power Query - Visually indicate native query steps

    Add a little icon for native query steps so that we are instantly aware which steps uses native query and where native query "breaks"

    Not I have to right click every single step to get this 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 →
  10. Data type in Power Query custom column

    In the dialog box that appears when you create a custom column, there should be a drop-down box where we can select the desired data type of the new column. As-is, we have to add a second step specifying data type or manually in the formula bar/advanced editor type ", type text" or whatever; it would be far more convenient to be able to do that right within the dialog box.

    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 →
  11. Field formatting multiple data types in a table

    In the field formatting section of a table, allow users to be able to change the data type of the column. Example: I have a custom selected measure that will give the results for both Sales or Units depending the selected slicer choice in a table. I need to have the Sales in currency format and Units in a whole number but cannot have both currently, only one of the other.

    9 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 →
  12. More evident LOAD/NOT LOAD format in queries list

    It's sometimes hard to spot which of your queries will load and which not. The cursive format is not evident first look and requires a bit of visual 'effort'. Maybe a nice Prussian blue font colour?... but that's my preference ;)

    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 →
  13. Include Count and count distinct like quick measure

    Those are two most of tipical measure with data.

    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. Add Refresh Groups

    Many complex Power BI models are using a high number of different data sources.

    Some of these data sources must be refreshed on a regular basis frequently (daily or weekly), other however less frequently (monthly or in case of target numbers, yearly refresh is enough)

    It would be great to introduce refresh groups, and assign each source or entity to a certain refresh group. When initiating a refresh, users would be able to select which refresh group to execute.

    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 →
  15. Show keys in direct multi dimensional queries on SAP BW4Hana.

    Show keys in direct multi dimensional queries on SAP BW4Hana for all dimensions and hierarchies.

    This is a show stopper for our SAP clients and worth millions in Power BI subscription. This would also be a killer feature against other BI tools that want to take the crown on displaying SAP data without extraction.

    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 →
  16. Add row number in matrix/table

    maybe an on/off button to add row numbers

    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 →
  17. Rename query steps without refreshing preview

    While renaming query steps (right-click rename OR right-click properties) when you apply the name change, it will re-run the query step. Why? Best practice to rename query steps yet for very large data sets this becomes cumbersome during the queries initial development. Note: I could be missing something valuable that would prevent this, please advise.

    16 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 →
  18. 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.

    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. previous few days, monthes, quarters, years function

    It seems like a good idea to add functions like PREVIOUSFEWMONTHES (<dates>, <period> number), days, years, quarters.
    it should work completely the same as PREVIOUSMONTH but return a data from defined quantity of previous periods

    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 →
  20. By default sum of _measure.

    If we drag _measure in canvas, then by default power bi will make it SUM.

    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.