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

machazthe gamer on 06 Jul 2020 00:13:11

RE: Regular Expressions support in Power Query

I was considering dropping Alteryx and using M instead but with this limitation, I can't risk it,

Marco's profile image Profile Picture

Jose Antonio Silva on 06 Jul 2020 00:12:45

RE: Regular Expressions support in Power Query

This is really sad to limit the language expressiveness like this. This is so simple to add from javascript or CLR. does not make any sense to reduce a data processing tool this way.

BTW: neither R ou web.page are a solution since they don't run native on Power BI Service.

Marco's profile image Profile Picture

Power BI User on 06 Jul 2020 00:12:12

RE: Regular Expressions support in Power Query

Regex are essential part of string manipulation. Should be a must for Power BI!

Marco's profile image Profile Picture

Marco on 06 Jul 2020 00:10:16

RE: Regular Expressions support in Power Query

RegEx in Power Query/Power BI should be a MUST for data analysis...

Marco's profile image Profile Picture

Power BI User on 06 Jul 2020 00:05:03

RE: Regular Expressions support in Power Query

While there are workarounds adding Regular expressions would be a huge boost to Power Query's functionality.

Marco's profile image Profile Picture

Eric JENOUVRIER on 06 Jul 2020 00:01:53

RE: Regular Expressions support in Power Query

Hi powerBi team, I got another project on which REGEXP was required, so we needed to go back to :

Solution 1 / Python or R script (but require usage of a Data Gateway :/)

Solution 2 / Make an Azure Function with 5 line of .NET taking in parameters a string + regexp to evaluate and return true/false, but making regexp out of powerBI + http request and all problem on data privacy handling on PowerBi online

Having Regexp supported in powerBI desktop/online (natively) will be a great help

Marco's profile image Profile Picture

Nemil Sheriff on 06 Jul 2020 00:00:51

RE: Regular Expressions support in Power Query

Please add RegEx support. Not having it makes Power BI less accessible.

Marco's profile image Profile Picture

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

RE: Regular Expressions support in Power Query

Lack of RegEx support limits quite a bit of import scenarios, work arounds not always possible (or compatible with PBI Service). Please bring in native support

Marco's profile image Profile Picture

Jan Bobka on 05 Jul 2020 23:59:29

RE: Regular Expressions support in Power Query

Pls do it

Marco's profile image Profile Picture

Brian Warn on 05 Jul 2020 23:58:30

RE: Regular Expressions support in Power Query

Regular expressions are ubiquitous. Tableau supports them. Why doesn't Power BI support them?

Merged Idea (2)