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. Change data types and other formatting functionality with SAP HANA DirectQuery

    The SAP HANA DirectQuery does not support data prep features like changing data types as well as other formatting changes. Without the ability to prep the SAP HANA data with DirectQuery, there is no way to leverage SAP HANA's real-time data capability. Thus, whenever a user needs to change data, they are forced to use Import (a static data set).

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

    Report consumers (department leaders) are asking for the ability to drill down into transactions. This is not currently possible as transactions are not part of the content pack. Account transactions should be included in the content pack.

    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. Edit Data Table From Relationship View window

    In the current relationship view window we can delete a data table from the model.

    It would be nice to right click on the data table and click edit query for the underlying table. This would immediately open up the query editor for data table changes.

    Today you have to switch views to the table view, and click edit table. or navigate to the edit queries button and click edit queries. Doing this opens the queries, but you still have to navigate to the table you want to change.

    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 →
  5. Design a power BI plug in throgh which all spss custom table can be detected once the analysed excel file is loaded. It should read each tab

    Design a plug in for SPSS through which each custom table is detected as potential chart automatically once the data is uploaded . Or at least make it powerful enough to perform survey analysis like SPSS. Becoz currently 60% of time goes in to manual report preparation in PowerPoint. Power BI can solve this problem of market research industry by enabling powerBi for powerful statistical analysis

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

    PDF connector - LOVE IT. Add the ability to apply same transformations to multiple pages / tables.

    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 →
  7. random data sample power query

    Enable an import of a random sample from a data source into Power Query.

    When loading the top 1000 rows, this tends to obfuscate data types and issues that may be in columns further down, especially when dealing with historical datasets with columns added at later stages and older data predominantly contains null values in these columns.

    It also masks the opportunity for proper transformation due to the lack of values.

    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 →
  8. Ability to filter the number of records based on the LEN (length) of a particular column through query editor for Odata / SQL sources.

    The feature should be able to filter the data or table coming in from our data source and be able to pull in only those data that are greater than or less than a certain amount of length.
    For example if we had a table with columns :
    Names, ID and Activity.
    And a million rows/records in them.
    But the report requires only the names which are greater than 10 in length. There should be a way to do it easily through query editor.

    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. Identify missing join values

    Recently some Column Quality and Column Distribution checks have been introduced into the Query Editor, which are great.

    A useful addition would be identifying Foreign Key values for which there's no corresponding Primary Key. A simple and common example of this would be identifying Customers who appear in the Sales fact table who don't appear in the Customer dimension table.

    The join created by the developer would identify the Foreign/Primary Key relationship, and perhaps any such orphaned Fact table records could be highlighted against the join itself.

    Currently such occurrences of this will usually result in Sales values posted against…

    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 →
  10. Import multiple PDFs and automate data integration

    Hi,

    My company has years of backlog of 3rd party PDF reports full of course important info.

    When I import a pdf, I have to do quite a bit of cleaning to fix the data.

    This may be possible, but I would love to clean a sample PDF that represents 1000+ similar reports in terms of structure, then apply the data cleaning queries to all of the files.

    Does this exist now? Haven’t cracked it.

    Thanks, Jared

    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. 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. email subscription to network drive location

    email subscription to network drive location. shat way individuals can setup a subscription to automatically save data files to a mapped network drive inside of an organization

    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. adding an additional filter after Filtered Row step does not combine the Filtered Step but instead creates another FilteredRow1 step

    Adding an additional filter after a Filtered Row step does not combine the Filtered Step but instead creates another FilteredRow1 step.

    Where as adding a Removed Column step after an existing Removed Column step simply appends them into the existing Removed Column step.

    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. Expanding data profile sample size to all records

    Hey Power BI dev team,

    I have had several customers say that they like the Power BI data profiling feature, but the rub is that they want to be able to sample all data rows and get more details around the statistical details of the profile.

    As always, great product and evolving in a positive manner.

    -Max

    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. Support on Weigthed Rate

    I´m sorry if this comment is obviously for someone; but I would like to hava a Weigthed Rate; this formule resums my problem:

    Weigthed Rate = Sum([credit/Total credits]*[Individual Rate)); by Analyst

    Credit is a column
    Total credits is the sum of credits
    Individual rate is a column
    And finally Analyst is a column with all the analysts that works in our enterprise

    So I would like to know about solve it.

    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. Please add new formats to Date data type

    Why can't you add formats for data that is Year/Week - 201901/201902/201903 etc. etc. or even Year/Month

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

    10 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. 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. Importa Txt com delimitador fixo

    O power não tem o recurso de importar arquivo txt com delimitador de largura fixa tão intuitivo quanto o existente no excel.

    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. reverse split column by delimiter

    When using the split column by delimiter, it would be great to have the option to reverse delimiter search.

    This would be useful in preparing some active directory outputs where you've been supplied the distinguishedname and want to put it in a hierarchy based on the OU structure.

    I can't think of an easier way to do this.

    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?

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.