FIltering Adobe Metrics in Power Query

[ajeyschune]

I am running into an issue where my Adobe query is pulling back too many rows of data, causing me to get the "Table is blank" error. I am trying to get daily UV and Visit counts for different campaign codes, and currently the query is pulling back a row for every campaign code defined in my segment even if there are 0 UVs/Visits on a given date. Is it possible to have my query filter out campaign codes that have a Visit or UV count =0 on a given date, so I am not pulling in unecessary rows into my results and causing the query to fail?

            {Cube.ApplyParameter, "DateRange", {#date(2020, 1, 1), #date(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()),  Date.Day(Date.AddDays(Date.From(DateTime.LocalNow()), -1)))}},
            {Cube.ApplyParameter, "Segment", {{"s300000384_5ea07884c897672e4e96a530"}}},
            {Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}},
            {Cube.AddAndExpandDimensionColumn, "evar1", {"evar1"}, {"(v1) Internal Campaign Code"}},
            {Cube.AddMeasureColumn, "Unique Visitors", "uniquevisitors"},
            {Cube.AddMeasureColumn, "Visits", "visits"},
            {Cube.ApplyParameter, "Top", {10000, "evar1"}}

"tab

[v-frfei-msft]

Hi @ajeyschune ,

Hope this case can help you.

https://community.powerbi.com/t5/Desktop/Adobe-Analytics-Connector-Limiting-Dimensions/td-p/676602