Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Support relative path to excel/csv sources

    Currently, when excel file is loaded to Power BI, the absolute filepath is captured in the M query. It would be nice if relative filepath was supported. Thus we could place excel file next to pbix and not worry about the file location (local machine, shared folder on server or onedrive)

    613 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    48 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  2. Regular Expressions support in Power Query

    We think regexp support will help the adoption of the Power Query tool in the most demanding use cases. Many thanks.

    525 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    32 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  3. Discard Query Changes

    The query editor only has two options "Apply Now", and "Apply Later". What if I've messed up my query and never want to apply the changes?

    Please bring back the ability to discard changes made during the time the query editor was open

    328 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    36 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  4. Fuzzy Comparison function for similar names

    For either a Power Query function or a new DAX function, we could use a fuzzy string compare to provide a score like 1 to 10 of the similarity of a string. I believe that SSIS has some functionality like this. For example we often has Company Names that we need to match to an external source and would like to get a score to compare names like "Wal-Mart", "WalMart","WalMart", "Division or WalMart", "Wal-Mart Stroes", etc. Does anyone else need this type of compare - or found a simple way to do it in Power Query?

    258 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  27 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  5. Ability to use wildcards in power query transformation find section of replace values.

    In the transformation area of replace values it would be nice to be able to use a wildcard in the value to replace field. For example we have transaction descriptions like... Placement [EB-12375596] and it would be great to be able to enter something like... Placement% to capture all of these. I've got several work-arounds but this would be a great feature for those who don't know SQL.

    243 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  12 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  6. When we add Custom Column, allow us to choose its position

    When we add a new column in the Query Editor, it always places the column at the end. This makes it difficult to visualy relate the new column with the other columns that were used in the calculation, and make if difficult to debug our custom column code. The workaround to use ordering after we add the column, is not user friendly if we have dozens of columns.

    It would be helpful, if we can choose the location of the column from the UI (with a default), and that you add a fourth optional parameter in Table.AddColumn for the column…

    157 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  7. Stop Executing Queries Multiple Times

    I create a query in Power BI Desktop against a data source. Power BI Desktop insists on executing it multiple (usually three) times. This makes Desktop slow and for back-end data sources exerts additional load that can also incur additional costs.

    Note: I am not talking about the scenario where a query is referred to multiple times in M, rather just a simple query loaded into one table in the data model. I assume the engine is checking data types, etc - but the current approach is very slow/painful. Optimisation is needed!

    97 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow us to have a global option to disable the automatic detection of column types

    Please allow us to disable the feature "Automatically detect column types and headers for unstructured sources" from Options --> Global, and not only from Options --> Current Workbook.

    Read here about the rationale for this request: http://datachant.com/2017/01/11/10-common-mistakes-powerbi-powerquery-pitfall-2/

    78 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add "copy rule" option to conditional column dialogue

    The conditional column feature is awesome! I would like to see an option to copy an existing rule since most of the time you only change the value when you add a new rule. It would be a minor improvement, but it's the little things that matter :)

    78 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    16 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  10. data format as bytes

    I'd like the ability to format a number as bytes (KB, MB, GB, TB, PB, EB)

    72 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  11. Disable Background Data Preview Refreshes Global Option

    Currently there is the option to disable background data previews in the "CURRENT WORKBOOK" section, but I find myself having to do this in every single workbook to prevent PQ from keeping my processor pegged out at 100% constantly. It would be great if there was a global option to disable these so there was no need to disable on a per-workbook basis.

    70 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  12. Convert between currencies

    It would be very useful to be able to convert between different currencies in one table to one common currency.

    63 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  13. Copy Multiple Measures between PBIXs

    After creating a set of great measures in one report, I may want to use them in another report, but there is no way to copy measures between PBIX's (other than selecting them one at a time and copying the DAX). It would be great to be able to copy multiple measures at one time to a different report.

    60 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 →
  14. Using git or some other SCCS to store M queries (NOT a data source)

    Power Query M queries are code and can benefit from a source code control system like Git for:
    1. sharing
    2. versioning
    3. backup

    It would be great if you could hit a button and either import or export a query to git or svn and whatever is the Visual Studio equivalent

    60 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  15. Include MissingField Argument with Table.TransformColumnTypes Function for Power Query

    From what I can see (and it's not listed in the M function reference) the built in Table.TransformColumnTypes doesn't accept the MissingField argument like most of the other Table functions. This is extremely troublesome because if you are processing a dynamic data source, columns could come and go. It would also seemingly be beneficial to potentially pull this into the Power Query UI and possibly even set this as the default.

    The reason I suggest this is that In most scenarios that I come across, failing to transform a column type is not always something that is "mission critical". Especially…

    56 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. Get current folder path in M language for dynamic folder path logic

    It's possible to get the current folder path of a file using a formula in Excel. This value can then be passed into Power Query. This works fine for data models and visualizations built entirely in Excel.

    If the model is built in Power BI Desktop, there's currently no method to land this data into the data model.

    55 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  17. Use Internal SQL queries instead of M language

    Why do we need to learn another language when we already know SQL for data preparation? 

    SQL is much more flexible and simpler that M language, and can use Partition and windows function. 

    Power BI users need to lean DAX functions and M Language and it is very frustration to learn 2 new languages for one tool, so why don't we just use SQL and DAX functions and eliminate to need to learn M language. 

    SAS did it with 'PROC SAS' and there is no reason that Microsoft won't be able to do it too.

    51 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  18. 51 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  19. Enable Regular Expressions for filtering and replacing values (REGEX)

    This would be a huge benefit and open so many benefits, if we are able to use regular expression in power query.

    50 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  20. PowerQuery - UI option to temporarily suspend a step

    In Powerquery, when I want to temporarily remove a step, I can either:
    1. Delete the step, then test without it, then recreate it
    Or
    2. Manually modify he M code by putting // and then resetting the names manually.

    I would appreciate a quick way to suspend a step in the UI - something like there is in vba

    49 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 43 44
  • 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.