Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Datetime filtering and relative

    When applying a filter to a Datetime value, there are four options: 'Advanced Filtering', 'Basic filtering', 'Relative Date', and 'Relative time'.

    What I want to filter, is showing only items with a Datetime value that is more than one month old. With advanced filter, I can choose values that are before an absolute date and time. With relative date,I can show items that are filtered by a datetime relative to the current date.

    My idea is to adjust the advanced filtering item to allow relative filtering.

    For example, below the 'Show items when the value:' line, there is still the…

    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. When will support for pdf input be added to excel power query?

    Extend pdf support to power query with excel in addition to support in Power BI desktop

    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. Composite Model for Multi-dimensional Cube (SSAS)

    It would be extremely helpful if I could have a composite connection possible for SSAS cubes

    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. Option to promote headers directly in the navigator popup

    When you load data. It would be great if an option to promote headers appeared straight away in the navigator.

    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 →
  5. I was just prompted to give feedback on Power BI. I did so, and hit enter, and the response I got was "Microsoft Power BI Community An Unex


    • an error has occurred etc etc. I my feedback, if it now acceptable, was: make formatting options easy, easy to find, Somewhere that I'
      ve missed so far there is some reasonable consistent way to format the blankety blank data - as there is in Excel, Word, Color the Pig games. But it remains a secret to this 55 year veteran of information systems work and employment by IBM, ITT, and finally my own publicly traded consulting company. The only consistent advice I've seen several times is "use the modeling tab". That does not work for me except if the…
    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. PowerBI can't recognize the html style of table in outlook email

    It would be nice to have the ability to recognize and hence expand tables in outlook emails.

    For example - I query daily emails with data tables, I have to go through quite a few steps to extract individual rows from the tables.

    If we instead had a way to recognize tables in the "Html Body" column, we could just use the expand table function.

    Thanks.

    -Keerthi

    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. New Calculated Table feature in Power Pivot

    Where is the New Calculated Table feature in Power Pivot for Excel? Four years ago I scrambled to my computer in exhilerated anticipation when I discovered Power BI had bi-directional cross-filtering capabilities only to discover this critical functionality was only available in Power BI not Power Pivot. Similarly, being able to easily create new intermediate calculated tables in Power Pivot would be a game changer but it too appears to be only available in Power BI. This, once again, is quite frankly devastating. Please tell me it's there and I just can't find 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 →
  8. selecting parenthesis or curly brackets should highlight the commas too

    A lot of times, parentheses and brackets contain sets of items separated by commas. When the opening or closing bracket is clicked, the pairing bracket is highlighted. This is very handy, but sometimes when there is a mistake in the bracket order this doesn't help as much as would be liked. If there are commas that separate the main items in the set (not subitems), then those should be highlighted too. In fact, when a comma is selected, the brackets or parentheses that give the comma context should also highlight. This would make troubleshooting and parsing M statements much much…

    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. Requried Week in Date Hierarchy

    Hi,

    Can you please add week in date hierarchy.

    Thank,
    K R RAO

    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. Export table as dataset

    Many times we discover certain data attributes and would like a larger picture with those attributes applied across the dataset or to be used in a different but similar dataset. This often involves going back to the query and preparing to add the attribute or splitting the attributes tables into multiple excels and joining and adding back to the data set. It would make a lot of "ease of use" sense to be able to right click and add the table straight to the intended dataset.

    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. Power Query M Support for Streaming Push Datasets

    I have trouble understanding DAX and think Power Query M is more intuitive. I have a Streaming Push Dataset that I need to "enhance". It would be easier for me to do most of the transformation via Power Query M but I don't think Streaming Push Datasets support Power Query M:
    https://community.powerbi.com/t5/Power-Query/Does-Power-Query-M-Support-Push-Datasets/m-p/1032964/thread-id/34989#M34994

    Please consider adding support to allow Power Query M (or Haskell [smirk] ) to process Streaming Push DataSets.

    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. Option to set color of powerquery windo

    I sometimes have to copy queries from one (older) pbi file to a newer version. That means I have two PowerBi desktop windows and two PowerQuery windows open. As all look the same in my Windows taskbar this often leads to confusion on which window i'm now looking at.
    Is it possible to change the colour of a window, or perhaps automatically add a number to the icon in the taskbar so I can more easily switch between windows and are less likely to make mistakes?

    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. Drag down numbers options

    While creating tables, add an option to drag down numbers similar to excel and sheets

    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. Regional Settings while Getting Data

    Many times I need to change the Regional Settings, but I just realize when I see the preview data while I'm getting new data. When it happens, I need to Cancel the import, go to "Options......", after many clicks I need to do every thing again to import (Get data) data corretcly. So, it will be very helpful to have the possibility to change the Regional Settings while the process of Get Data occurs.

    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. Parameters that are set up as a list should be restricted to the options on the list

    If you set up a parameter in query editor as a list of options, users can still switch the parameter to whatever they type in. It doesn't make sense to let us set it up as a list but accept any input.

    Example: https://i.imgur.com/pVwyVBS.mp4

    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 →
  16. Data Preparation UI same as MS Excel

    Data View in Power BI desktop should allow same interface for adding columns and applying formulas as in Excel. Current UI is a bit complicated

    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. Single object vs. multiple objects

    In Power Query, I never understood the logic behind the usage of single usage objects and have it store its result and make it reusable throughout the script.

    It leads to problems when changing source's format.

    I'm thinking about switching back to R for data transformation.
    I have been working on a data transformation script that I now have to rebuild from scratch because I keep getting an error about the file format (caused by using 64 bit version with 32bits excel files).
    I'm pretty sure that if it was a real scripting environment with variables declaration and proper memory…

    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. DAX function to create an index column in the original query order

    With Microsoft support I understood that there's no way in DAX to create an index column in the original order passed by query, the only way for now is with power query, but this is a limit in some 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 →
  19. performance please

    How come I run a simple merge and aggregate on a couple of tables takes forever to complete?
    I run the exact same transformation in R on a single CPU Core and it takes seconds!!!
    In Power Query? It's been running for about 15 minetus so far with CPU through the roof on all 4 cores with hyper-threading (so it's technically 8 cores)

    I've looked for optimization but I really shouldn't have to. This should be simple but clearly somehow M has found a way to make it complex.

    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. The navigation tabs reports, table and relationship should be able to view them in independent windows.

    The navigation tabs report, table, and relationship should be able to view them in independent windows.

    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?

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.