Does PowerBI support regular expression

[changhai]

I wonder if powerbi supports regular expressions. I checked on the Internet that it seems that it is not supported, which can only be implemented through Python or R. But my case is directquery mode with Google bigquery, bigquery itself can support regular expression query very well. And the amount of data is very large. I don't know what regular expression the user will enter to query in advance. Can powerbi support to modify query statements sent to bigquery?

Thanks

[Mariusz]

Hi @changhai 

You can use DAX to modify query statements sent to bigquery.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn