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. Promote selected headers only

    It'd be nice to promote the first row into headers but only for specific 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 →
  2. 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 →
  3. 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 →
  4. Skip bad rows at Load stage

    Recently we came with an issue related to wrong formats in data, at Load time if you have bad data you will have an exception and information wont load.
    We need a feature who allows you to skip bad data when you load the information and the option to see rejected records.

    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 →
  5. 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 →
  6. isnull()

    Please add isnull() to powerquery

    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. 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. 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 →
  9. 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 →
  10. 'Lazy Preview' option in Query Editor when merging / joining queries

    I have a query in which I am joining to another query. The preview need only return a couple of hundred rows. However, the query editor has just spent the last HALF HOUR churning through all 5 million rows in the background, in the multi-gigabyte mashup container (which eats my laptop). I really don't see the need for this! All it has to do is find enough records to create a sufficiently large preview (200 rows will do!) and then STOP. Only when I press Apply should it then attempt to go process everything. Otherwise, I'm subjected to this extremely…

    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. I need a "$" "$" a "$" is what I need!

    Add the ability to place a "$" or "%" or other style prefixes/suffixes of different numerical data types. WITHOUT Changing the data type of the numerical column to a text/string value.

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

    Example file:

    AAA"BBB

    CCC-DDD

    EEE-FFF

    Fixed Width: 0,3

    Only the first row is imported.

    bypassing erro:

    let
    Fonte = (nome,conteudo) => let
    s = Text.BeforeDelimiter( Text.FromBinary( conteudo ),"#(cr)#(lf)"),
    c = Text.Length(s) - Text.Length( Text.Replace( s,"""","") ),

    r = if Number.IsEven(c) then #"Transformar Arquivo de empenhos"(conteudo)
    else error Error.Record("Erro ao importar arquivo """ & nome & """","A primeira linha não pode conter um número impa de aspas (" & Number.ToText(c) & ")", null)

    in
    r
    in
    Fonte

    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. "There's already a relationship between these two columns" - tell me what the relationship is

    When creating a new relationship between two columns sometimes Power BI returns this error - "There's already a relationship between these two columns". Please can you add a feature to tell us what the conflicting relationship is?

    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. Better Relationship Management

    New tables are placed on the canvas miles away from where they're needed and are slow to drag - fix this by:
    Creating an 'Unlinked tables' panel where new tables sit until they are placed on the page
    Having a hide option for tables in this panel (because some tables, e.g. for Measures never need adding to the canvas)
    It's also hard to see what relationships exist in a complex model.
    Fix this by adding a summary of each relationship to the properties panel visible when you click on 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 →
  15. Update Power Query to allow all SQL Server functionality

    Power BI is missing 3 very basic features that are available in just about every other tool connecting to SQL Server:

    1. Synonyms. Right now Power BI can only "see" tables and views - but synonyms should be queryable. No different than querying a table or a view...

    2. Pushing down queries that cross databases on the same server. I can easily write a SQL statement that joins tables on two different databases on the same SQL server instance, but Power Query treats these as incompatible and won't push down any SQL that does this. This results in huge performance…

    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. 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 →
  17. 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 →
  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. 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 →
  20. Export Data From Visualisations as they appear in PowerBI

    It would be good to be able to export data that appears in PowerBi visuals in Excel in the format as they are presented. Currently export will retreive the underlying data and not how it has been pivoted/presented within PowerBI.
    Benefit of this is that the investment in time to get it ini that format is not wasted (or needs more time to redo in excel) if that data is needed for other teams to use

    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 →
← Previous 1 3 4 5 36 37
  • 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.