I 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. <code>ga
agePath=~^.*?([0-9]{6,7}|mpg[0-9]{1,3}){1}\.html[/]?[^ ]*</code>)
I could use "<code>Table.SelectRows</code>", but as M doesn't support regex, this filter should be passed to GA api directly. Here is what M generated for me:
Is there any possiblity to pass my regex filter to GA api in M?

I could use "<code>Table.SelectRows</code>", but as M doesn't support regex, this filter should be passed to GA api directly. Here is what M generated for me:
Code:
<code> 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"
</code>