Power BI

Needs Votes

Regular Expressions support in Power Query

Vote (969)

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 (76)

Power BI User on 05 Jul 2020 23:55:59

RE: Regular Expressions support in Power Query

regex is "THE" processing string tool. We need it!

Hong on 05 Jul 2020 23:50:59

RE: Regular Expressions support in Power Query

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

Saur Dash on 05 Jul 2020 23:46:02

RE: Regular Expressions support in Power Query

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.

ChrisA on 05 Jul 2020 23:45:23

RE: Regular Expressions support in Power Query

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 on 05 Jul 2020 23:45:21

RE: Regular Expressions support in Power Query

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

Mats Bengtsson on 05 Jul 2020 23:34:46

RE: Regular Expressions support in Power Query

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.

Power BI User on 05 Jul 2020 23:31:45

RE: Regular Expressions support in Power Query

I'm also shocked. It's a must have.

Anonymous on 05 Jul 2020 23:31:27

RE: Regular Expressions support in Power Query

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 ?!!

Power BI User on 05 Jul 2020 23:18:52

RE: Regular Expressions support in Power Query

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.

Power BI User on 05 Jul 2020 23:18:21

RE: Regular Expressions support in Power Query

Very important ideia, I use already regex in Tableau Desktop and Python. It should have this function in Power BI.

Merged Idea (2)