Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

chrisread79

Create Power Query Text functions for REGEXTEST, REGEXEXTRACT, and REGEXREPLACE

Submitted by Advocate I on ‎09-24-2025 02:03 AM

We desperately need the REGEX functions added to Power Query. Excel has already had these added in 2024 (REGEXTEST, REGEXEXTRACT, and REGEXREPLACE). See for reference Excel REGEX blog.

 

Yes, Python can be used for this, but this requires a Personal Gateway.

Yes, the javascript hack can be used for Power BI Desktop, but this does not refresh in the Power BI service.

 

This is a basic function that has also been applied in Power Apps Power Fx.

Status: New
See more ideas labeled with:
Comment