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. Quick measure should have scalar operators .eg if I want to multiple a column with a fixed variable

    Quick measure should have scalar operators .eg if I want to multiple a column with a fixed variable

    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. COUNTIF in DAX Language

    A COUNTIF is sorely missed in DAX.

    (The workaround with CALCULATE and FILTER is too cumbersome and complex for most users)

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

    9 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. BUG? Fixed Width File not Loading all rows if contain only a single quotation mark in line

    Example file:

    AAA-BBB

    CCC"DDD

    EEE-FFF

    Fixed Width: 0,3

    Only the first row is imported.

    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 →
  5. 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 →
  6. Apply sort algorithm across rows in power query

    Currently we can sort (asc/dsc) vertically in columns in power query. I would like to apply a sort across multiple columns row by row based on selected columns. I do have a business case for this with financial dimensions in D365FO.

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

    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. Composite Models for Power BI Data Sets

    I often get requests that are derivates of already released reports, but require small tweaks, such as a new dimension to be added to answer. Being able to add composite table to a live data set connection would enable me to more effectively re-use my work, as I wouldn't have to start my project in an already complex pbix file. just a live connection, a look up table an a blank canvas.

    18 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 →
  9. Auto groups using exact or fuzzy match

    If you have a long list of unstructured values, greating groups can be laborious and potentially needs revisiting when the data refreshes. It would be nice if the 'create group' feature could have an automation feature to auto-group either by exact match or fuzzy match. Even a simple keyword search to filter the values in the left pane would help to speed up the process of creating groups manually.

    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. Allow for column (not measure) value to be determined from a Parameter

    Just recreate the Parameter functionality in Tableau.. where an end user can pick a value from the parameter selection, and have a column update it's value based on the selection.

    Right now you can only change the value of measures by a slicer / what if parameter, and we really need to be able to let users determine the value of columns.

    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. Add Table.AddKey Functionality to UI to Optimise Queries

    It seems as though there is a performance benefit to query runtime when manually adding keys which currently has to be done in M

    (see: https://blog.crossjoin.co.uk/2018/03/16/improving-the-performance-of-aggregation-after-a-merge-in-power-bi-and-excel-power-query-gettransform/)

    This may be particularly true when creating a join on a csv, for example, where a foreign key may vastly improve performance.

    Please allow us to do this in the UI rather than needing to modify the M behind a table

    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. In the Query Editr, add the merged column after the column where I currently am, and not at the end of the table

    After mergin columns is adding the column at the end.
    This adds another step, to move the column to the right place.

    Would be possible to select the position of the new column, by clicking on a column and then clicking on Merge.
    The new column will be then added after the column we currently are.

    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. Automatic 'Unknown Member' generation when relating tables

    In some circumstances, it's not desirable for data to be excluded from a visual because for some of its fields there is no data. The 'Show Items With No Data' feature mitigates this but enabling it causes refresh to take MUCH longer - too long to be acceptable to my users. An alternative is an option for PBI to automatically generate unknown members in tables that the user creates relationships for. Any textual fields would default to '(Unknown)' in this case.

    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. Column Profile Show Number Distributions

    For the Column Profiling it would be nice to see the distribution of Number Data Types in a histogram based on the Number as an axis, rather than the Count of Occurrences on the axis.

    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. Export Data show data from PowerBI Dashboard to Excel

    We use SSAS tabular data cubes to power our PowerBI visualization. The same information can be obtained by connecting to the data cubes via excel to pivot the information inside of our cubes. However, our customers often say would be great to be able export the data used directly from the PowerBI charts.
    I would like to tell them yes they can pull the data directly from the visualizations in PowerBI with their pro license.

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

    I agree with everyone who says the new data profiling is great. Can you extend it's capability by allowing us to chose to save the metrics, perhaps to Excel or a SQL Server table, so that we can use that historical data to build Power BI reports against the data showing a kind of data quality improvement over 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 →
  17. Data Profiling

    I agree with everyone who says the new data profiling is great. Can you extend it's capability by allowing us to chose to save the metrics, perhaps to Excel or a SQL Server table, so that we can use that historical data to build Power BI reports against showing a kind of data quality improvement over 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 →
  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

    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. Allow export to Excel from all versions of Power BI

    The limitation of having one option to export data frustrates our desktop customer base as we look to add Power BI to our reporting toolkit. Please include the export option for Excel that exists within the Pro and Premium versions. The added steps needed to convert the csv file to an xlsx becomes a training issue and is time consuming for our end users.

    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. Give the possibility to switch column positions in the Data tab

    Even though the Data tab isn't made to visualize data, it's sometimes very useful to organize the columns in a specific order. Sometimes, I create columns after others, but would like to see them before. This is possible to do but very complicated - would there be a way to create a quick functionality to switch column positions easily ?

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