Solved
Filter by dimensions on fetch of data
Hi,
I'm connecting Adobe analytics to Power BI (have also checked pbi forum - someone referred me here). I want to filter items on import (otherwise dataset is too large). I want to include two values for "Marketing Channel 1D MR". Those are "SocialMedia" and "SocialMediaOwned".
I've tried with applyparameter at end of code but i'm getting below error;
Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Id=variables/evar31.1
Table=[Table]
Have included code used below - error coming from last part - applyparameter. If anyone has an idea if I can do this/what code should be, would be much appreciated.
= Cube.Transform(vrs_landse0_landsendcomprodcda,
{
{Cube.ApplyParameter, "DateRange", {#date(2022, 10, 25), #date(2022, 10, 25)}},
{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"variables/daterangeday"}, {"Date Granularity.Level 3: Day"}},
{Cube.AddAndExpandDimensionColumn, "variables/evar31.1", {"variables/evar31.1"}, {"Marketing Channel 1D MR"}},
{Cube.AddAndExpandDimensionColumn, "variables/campaign", {"variables/campaign"}, {"Tracking Code [campaign]"}},
{Cube.AddMeasureColumn, "Orders [purchase]", "metrics/orders"},
{Cube.AddMeasureColumn, "Revenue [purchase]", "metrics/revenue"},
{Cube.AddMeasureColumn, "Units [purchase]", "metrics/units"},
{Cube.AddMeasureColumn, "Visits", "metrics/visits"},
{Cube.ApplyParameter, "variables/evar31.1", {{"SocialMedia", "SocialMediaOwned"}}}
})