Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Using the Google Analytics connector again.
let Source = GoogleAnalytics.Accounts(), #"Account" = Source{[Id="xxx"]}[Data], #"Site" = #"Account"{[Id="yyy"]}[Data], #"View" = #"Site"{[Id="zzz"]}[Data], #"Added Items" = Cube.Transform(#"View", { {Cube.AddAndExpandDimensionColumn, "ga:yearMonth", {"ga:yearMonth"}, {"Month of Year"}}, {Cube.AddMeasureColumn, "Pageviews", "ga:pageviews"}, {Cube.AddMeasureColumn, "Avg. Time on Page", "ga:avgTimeOnPage"}, {Cube.AddMeasureColumn, "Entrances", "ga:entrances"}, {Cube.AddMeasureColumn, "Unique Pageviews", "ga:uniquePageviews"} } ), #"Filtered Rows" = Table.SelectRows(#"Added Items", each [Month of Year] = "201605"), #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"Unique Pageviews", Order.Descending}, {"Pageviews", Order.Descending}}) in #"Sorted Rows"
the resulting table still has a row for every month. Power BI bug I assume?
Interestingly, if I add
{Cube.AddAndExpandDimensionColumn, "ga:pagePath", {"ga:pagePath"}, {"Page"}},
Then the filtering does work. So this is a strange bug.
@intrasight, I already reported your issue internally, will post here for any updates.
@intrasight, could you please help to provide one .pbix file with which we can quickly reproduce your issue?
@intrasight, we fixed this issue, it should be available to you in the release that will be around the end of September.
Thanks for reporting this to us!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.