Forum Discussion

jianfajun's avatar
jianfajun
Advocate II
1 year ago
Solved

Regular Expression Functions (REGEX) in Power Query

Hello, I made some regular expression functions in Power Query to enhance text processing capabilities. Background: Currently, Power Query primarily relies on basic text functions such as Text.Co...
Tips and Tricks
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Thank you, lbendlin , for your response and valuable advice, which will greatly benefit the members of the Microsoft Fabric Community.

    Hi jianfajun,

    We sincerely appreciate your efforts in sharing this valuable information with the community. Your contribution in providing regular expression functions in Power Query to enhance text processing capabilities is highly commendable. This will undoubtedly benefit other community members seeking similar guidance.


    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi jianfajun,

    To enhance the visibility of this discussion within the forum, we kindly request you to mark this response as the accepted solution and extend kudos. This will assist other members encountering similar queries in easily finding the relevant information.

    Thank you.

IvanShishkov's avatar
IvanShishkov
Regular Visitor
9 months ago

Hello,

great post but as of today this solution is not suported by powerBI service so it is not possible to refresh such dataset online.

The error is: The module named 'Html' has been disabled in this context.. Microsoft.Data.Mashup.ErrorCode = 10535.

Anything using Web.Page() is not going to work.

I've tried emulating same result but using HTML.Table() but a) I wasn't able to, and b) perhaps it will throw the very same error for the very same reason.

 

Any idea how to do regex text compatible with BI service? 

Thank!

PierreL69's avatar
PierreL69
Helper IV
2 months ago

Hi I have the same issue as you did you find a work around to it ? 

Thanks

  • IvanShishkov's avatar
    IvanShishkov
    Regular Visitor
    2 months ago

    I'm not aware of any developement on this. A possible work arround is to host a simple page on your hosting where to send the prompt and get a responce. Like: https://mysite.com?s=1233445&p=[0-9] and get a true or false responce back.

      • PierreL69's avatar
        PierreL69
        Helper IV
        1 month ago

        Thanks for the idea but I do not have a server/PC that is always running & has python running on it. 

        I overcome my issue by runing my regular expression at source level.

        Hovewer it is a shame that regular expression are now natively available in Excel but not in Power bi.

        Thanks