How can we improve Power BI?

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.

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

We’ll send you updates on this idea

Marco shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

23 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Hong commented  ·   ·  Flag as inappropriate

    regex is definitly a MUST support in string processing! Absolutely needed.

  • Saur Dash commented  ·   ·  Flag as inappropriate

    Another request here for REGEX support. While a huge amount is possiblewith existing M Code and the excelling Power Query UI, I've encountered a situation where I absolutely need to use REGEX to extract certain patterns from a field.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I need to use regex to parse a string representation into a lists of values. Please add this! Quite common to convert unstructured data into data that can be reported on.

    ~400 votes are here now for regex support!!

  • Vitalii Martyniuk commented  ·   ·  Flag as inappropriate

    Nothing has been going on for almost four years, when do you implement RegEx in Power Query, Power BI?
    Don't delay !

  • Mats Bengtsson commented  ·   ·  Flag as inappropriate

    The lack of built in Regex is a great shortcoming in Power Bi. Fixed in SQL server long time ago, but lacking as soon as one uses Power Bi directly without SQL server as middle man.

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is completely necessary !!! I need to replace a column that "contains" certain data (not the complete occurrence) this is so basic!! please implement it ASAP!! this has been here for so long !! 3 years and you can't put it ?!!

  • Anonymous commented  ·   ·  Flag as inappropriate

    Microsoft please we need RegEx natively in Power Query. The cheapest text editors have it in one form or another, it should be available in your flagship BI product.

  • sajjad commented  ·   ·  Flag as inappropriate

    This is should be helpful compared to other tools (like Dremio or any other open source tools)

  • O commented  ·   ·  Flag as inappropriate

    Agreed. I will use Python instead of Power Query or M because of this. This is a crucial element to data cleanup and I need this in virtually all of my data files. Very disappointed that M does not support this.

  • Yan commented  ·   ·  Flag as inappropriate

    You can use R to pre-filter using regexp but I am tired of workarounds, especially if cumbersome.
    Looking at the recent PBI releases, it seems most changes were made on the front-end rather than more functions in the query/filter engine. Too bad. Note that Tableau, Qlik and Spotfire have regexp implemented for quite some time.

  • Yan commented  ·   ·  Flag as inappropriate

    You can use R to pre-filter using regexp but I am tired of workarounds, especially if cumbersome.
    Looking at the recent PBI releases, it seems most changes were made on the front-end rather than more functions in the query/filter engine. Too bad. Note that Tableau, Qlik and Sptfire have regexp implemented for quite some time.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Wow. What's a dev gotta do to get regex support in powerBI? Beg? (I have no ego here)

  • Tim Rodman commented  ·   ·  Flag as inappropriate

    This would be very powerful, especially when combined with filtering data based on regular expressions.

  • Sean Horowitz commented  ·   ·  Flag as inappropriate

    Is there any movement on this issue? Regex support would greatly improve adoption and use of Power Query/M Script, I know a number of potential users that find this a missing feature that results in far too many tedious and complex workarounds to solve data clean up and pattern matching issues that would be relatively simple with regex.

  • Jannis Lietzau commented  ·   ·  Flag as inappropriate

    This would be very, very helpful. Please implement!
    Strongly supported this feature with 3 Votes!

← Previous 1

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.