Power BI

Needs Votes

Regular Expressions support in Power Query

Vote (970)

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)

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...

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.

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

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.

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