Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jnrezk
Helper III
Helper III

How to add RegEx in a filter for in Advanced Editor for Google Analytics connector

Essentially I want to do this but 5 years ago when this was asked it was not possible and I was wondering if anything has changed:

https://stackoverflow.com/questions/36373406/how-to-filter-dimension-values-when-fetching-data-from-...

 

 want to fetch data from Google Analytics With M (PowerQuery/PowerBI), but want to filter the dimension values on the fily, Let's Say my dimension is "Page" and I want "Pageviews" and "Unique Pageviews" measures, provided that the "Page" is following a regex filter (ex. ga:pagePath=~^.*?([0-9]{6,7}|mpg[0-9]{1,3}){1}\.html[/]?[^ ]*)

I could use "Table.SelectRows", but as M doesn't support regex, this filter should be passed to GA api directly. Here is what M generated for me:

    let
    Source = GoogleAnalytics.Accounts(),
    #"1234567" = Source{[Id="1234567"]}[Data],
    #"UA-987654-1" = #"1234567"{[Id="UA-52004541-1"]}[Data],
    #"11111" = #"UA-987654-1"{[Id="1234567"]}[Data],
    #"Added Items" = Cube.Transform(#"11111", {{Cube.AddAndExpandDimensionColumn, "ga:pagePath", {"ga:pagePath"}, {"Page"}}, {Cube.AddMeasureColumn, "Pageviews", "ga:pageviews"}, {Cube.AddMeasureColumn, "Unique Pageviews", "ga:uniquePageviews"}}),
    #"Filtered Rows" = Table.SelectRows(#"Added Items", each Text.Contains([Page], "html"))
in
    #"Filtered Rows"

 

1 REPLY 1
mahoneypat
Microsoft Employee
Microsoft Employee

You need to use R or Python in your query to do this.

 

Using Regular Expressions(RegEx) in Power BI | by Shivam Shukla | Medium

 

Or with javascript like shown here.

RegEx in Power BI and Power Query in Excel with Java Script – The BIccountant

 

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.