Power BI

Needs Votes

Regular Expressions support in Power Query

Vote (622)

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

Comments (41)

e17ff2f6 a938-4020-b83e-76e254f7b87b 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

d37dfe22 2c48-44cc-833e-57344ab9cc9c 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.

5d7b2bd7 174b-46af-bdbf-29e026ab3ab6 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