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.

340 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    18 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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.

      • Colin Banfield commented  ·   ·  Flag as inappropriate

        Absolutely required for advanced cleansing and validating data in columns.

        Regex.Replace, Regex.Match, Regex.Matches, Regex.IsMatch, Regex.Split

        Could also be part of Text functions, e.g., Text.RegexReplace

      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.