Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This GA connector looks a bit basic.
How would you filter on date with it - it seems to pull all the data it can at the moment.
Im looking to pull the last 28 days data aggregated so it can count unique users. So i need to filter by date without including the date field as a column.
Is there a manual line or two I can add to to the query?
Here is my expression i want to date bound on import.
= Cube.Transform(#"105237604", { {Cube.AddAndExpandDimensionColumn, "ga:userAgeBracket", {"ga:userAgeBracket"}, {"Age"}}, {Cube.AddAndExpandDimensionColumn, "ga:userGender", {"ga:userGender"}, {"Gender"}}, {Cube.AddAndExpandDimensionColumn, "ga:pagePathLevel1", {"ga:pagePathLevel1"}, {"Page path level 1"}}, {Cube.AddMeasureColumn, "Users", "ga:users"} })
Hi @StephenF
As a workaround you can import your GA data into windsor.ai account and access the data with Power BI.
You can also filter the last 28 days to import and get the number of unique users.
Hi @StephenF ,
Did you want to filter your data by parameter in power query? Please refer to this case.
https://community.powerbi.com/t5/Desktop/Power-Query-Current-Date-Filter/td-p/67586
I'm not trying to filter the rows post import. I'm trying to filter in the API call.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |