Skip to main content

Power BI

Needs Votes

Regular Expressions support in Power Query

Vote (993) Share
Marco's profile image

Marco on 16 Jul 2015 14:17:27

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

Comments (79)
Marco's profile image Profile Picture

Nic Ecker on 25 Aug 2021 15:28:25

RE: Regular Expressions support in Power Query

Just wasted two days on filtering issues that would have been solved in 5 minutes with regular expressions. This is not only badly needed, it should be a basic feature of Power Query !!

Marco's profile image Profile Picture

Sira Ekabut on 20 Jul 2021 14:22:04

RE: Regular Expressions support in Power Query

I've created Custom M Code function to let Power Query in Excel & Power BI able to use RegEx.
pls feel free to try my code. https://www.thepexcel.com/power-query-regex/

Marco's profile image Profile Picture

Dave Welden on 02 Jul 2021 21:07:30

RE: Regular Expressions support in Power Query

It's 2021 and Microsoft ♥ Linux. Time for some Regular Expression ♥ for Power Query. Can't be that hard to add from the .Net libraries.

Marco's profile image Profile Picture

Rajesh Anbukadal on 02 Jul 2021 13:58:08

RE: Regular Expressions support in Power Query

Having Regex withing PowerBI query editor will be an added advantage for data clean up and transformation

Marco's profile image Profile Picture

on 22 Jun 2021 22:57:58

RE: Regular Expressions support in Power Query

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

Marco's profile image Profile Picture

on 22 Jun 2021 22:57:36

RE: Regular Expressions support in Power Query

Enable regular expressions in conditional columns. Condition 'contains' is not sufficient in some cases.

Marco's profile image Profile Picture

Matias Tapiero on 12 May 2021 07:16:35

RE: Regular Expressions support in Power Query

Doing replaces on strings using REGEX would be so beneficial for data transformations.

Marco's profile image Profile Picture

Jason Maskell on 30 Mar 2021 03:04:14

RE: Regular Expressions support in Power Query

So desperate for this. I have a complex regex for processing text which contains complex array data that I get from another data source. To replicate this using native M functions will be a nightmare. Report server doesn't allow R or Python scripts to be run, which would prevent auto refresh. Very frustrating. I would have thought it would be a basic function. Just integrate an existing REGEX library from python or somewhere into the M language, and have it iterate over one text cell at a time in a column.

Marco's profile image Profile Picture

Andrey Levashov on 25 Mar 2021 07:10:53

RE: Regular Expressions support in Power Query

Python is a good workaround but it does not work if you are going to schedule report refresh on server side. Vote for Regex in Power Query M.

Marco's profile image Profile Picture

Geof Power BI User on 05 Mar 2021 17:06:11

RE: Regular Expressions support in Power Query

Yes, vital! Workarounds using R and Python scripting then prevent scheduled refresh without personal gateways, which is a non-starter for several reasons.

Merged Idea (2)