Forum Discussion

changhai's avatar
changhai
Frequent Visitor
6 years ago

Does PowerBI support regular expression

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

1 Reply

  • Mariusz's avatar
    Mariusz
    Community Champion

    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