Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. (bug) CALENDARAUTO() appears broken?

    Hello,
    When you use CALENDARAUTO() you have the option to supply your financial year end month, so CALENDARAUTO(3) for march.

    However when a date hierarchy is created on your date table the quarters are still based on the jan-dec values.

    Clearly, if I set my financial beginning of the year as April, then April-May-June are the first quarter, not Jan-Feb-March as the auto date hierarchy creates 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 →
  2. delete multiple measures

    Allow select and delete several measures at one time.

    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 →
  3. 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. have dates automatically set to short date

    Have dates automatically set to short date or whatever it was displayed as in 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 →
  5. Edit PWBI File on RS

    It would be beneficial if the PWBI file could be edited diretly on the RS that live data is available when designing the report

    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. Option to sync PWBI files before downloading from RS

    When designing a report it would be beneficial if the PWBI Desktop file whóuld contain the data from the Report Server

    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. Provide the option to list fields by their order within worksheets and other objects OR alphabetically.

    Currently the FIELDS area lists fields by alphabetic order within a data object (or EXCEL file). There is no option to display fields in the order they appear in the data object or in the EXCEL file. This makes it more difficult to find fields because they are out of order and scrambled when compared to an Excel workbook or data file.
    Therefore, Provide the option to list fields by their order within worksheets and other objects OR alphabetically.

    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. Hide Multiple columns based on type (for example all keys at the same time) in search or selecting multiple columns at the same time .

    Hide Multiple columns at the same time by typing for example Key, then I want to hide all my keys at the same time, because many customers are not using keys as end users.

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

    Search for the term 'dimension' in this list, and see how many suggestions are done, reflecting the need for better management of dimensions in Power Bi.
    If you collect these proposals it may be neccessary tot make a separate 'dimensions sections' in the most left column of Power BI.

    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. Please create a feature like query plan for Power Query

    As far as I know, PQ creates some internal presentations for calculating M scripts, reshuffling M queries and making something like tunnels/pipelines to data source from a number of steps, which are described in M scripts.

    E.g. internally

    s0 = #table..,
    s1 = Table.AddColumn(s0,"2", each f(_)) ,
    s2 = Table.RemoveColumns (s1,"1")

    is the same as

    s0 = #table.. ,
    s1 = Table.TransformColumns(s0, {"1", each f(_)})

    Defenitely, it would be great to virtually see the resulting "tunnels", just like SQL programmers can see query plans of SQL queries.

    It would help M developers in many ways, e.g.:

    1. They could really…

    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 →
  11. List (and /or Remove) Unused Columns in Data Model

    User built a report with a "Select * ..." query that imported 100's of columns. He used a few dozen columns, spread over many pages. It would be good to have a way to identify all the columns not used anywhere (M, DAX or visualizations) so we can clean up the data model. Idea: gray out unused columns in Power Query, or in Relationships, or Data would help. Better, extend to a list so we can uncheck columns we might use and a button to bulk delete all the checked 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 →
  12. Seria interessante poder inserir mais horários para atualização automática ou tempo real a atualização...

    Seria interessante poder inserir mais horários para atualização automática ou tempo real a atualização...

    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. Lock Applied Steps in Power Query to prevent accidental changes

    In the Power Query editor, it would be helpful to have an option to prevent a query from being edited. Due to the way Power Query sets its initial focus open opening it, there have been many times I've accidentally made changes to an intermediate query (that looks like the query I'm really wanting to change) but then I don't realize when/how/where the problem occurred until I go digging trying to troubleshoot unexpected behavior in a visual.

    There have been times I've unintentionally made changes to a query's Applied Steps while reviewing details on a particular step. Usually, I'll realize…

    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. Create an alternative calendar based in automatic CALENDARAUTO.

    Some companies start their FY in July so would be great to have an option or function to easily relation begining of Natural year with beginig of FY.

    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. Indexing after splitting table to separate fact and metadata tables

    Power BI currently offers the ability to make copies of a table and model so that (for example) amongst the copied tables one becomes the fact table and others become the metadata tables. However, there is not a way to create index keys (as primary keys) in metadata tables that are replicated in the associated fact table as foreign keys. This would be a great feature that would enable better modeling and 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. Table.AggregateTableColumn returns wrong data when input table contains null values

    After using the "merge queries" function (in the "home" tab of the query editor) to perform a left join, the resulting table contains null values in columns from the right-hand table...this is expected and normal behavior. However, when I then use the Table.AggregateTableColumn function to summarize the data--specifically, I'm adding COUNT aggregations--the output treats the null values as non-null.

    For example if I have a column with order numbers and a column (from the left-join) with product quantities in it, and if the order # did not match any rows in the right-hand table, then order product quantity would be…

    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. Delay / pause query update while editing

    I would like to be able to stop the automatic update of a query when editing an existing step. This adds a lot of wait time that I’d like to try to save if possible.

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

    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. Fuzzy Merge Similarity Output

    Fuzzy Merge Similarity Output. Like excel, it would be nice to display the similarity % used in the threshold calculation.

    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. Send filtered/sliced data into R and Python

    It's great that Power BI already has the capability to run R scripts for data localisation but the down part is that Power BI won't be able to update the result set by applying the filter/sliced data like Tableau does using the R SCRIPT_*() functions - SCRIPT_BOOL(), SCRIPT_INT(), SCRIPT_REAL(), and SCRIPT_STR().

    If we could get these functions in Power BI then it will be great.

    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.