Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
So I recently found out Regexp is not supported by Power BI. I wonder why would they not put anything as powerful as that in PowerBI.
Anway, this has put me in a situation where I am unable to create a logic in Power BI for below logic in Tableau
CASE
REGEXP_MATCH([Error_Message],'.*PowerBI_needs_to_support_Regexp.*') Then TRUE
END
The above expression means that
Any suggestion how to do that in PowerBI without using Python or R?
hi @anshusaketsingh ,
try to add a calculated column like:
column =
CONTAINSSTRING(
[Error_Message],
"PowerBI_needs_to_support_Regexp"
)
I am not looking for substring funtion , I am looking a way to check if first character is a character and then there are numbers only before substring begins, a containstring won't do that
Hi @anshusaketsingh ,
According to your statement, I think your requirement is to achieve your goal like regular expression in Power BI Desktop.
As far as I know, Power BI doesn't support this function directly. However you can try Python Script to do this.
Please refer to below blog to learn more details.
Using regular expressions in power bi desktop - Microsoft Fabric Community
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |