Issues with Google Analytics Data

Hi All

I am trying to pull some website stats from Google Analytics, I understand that there is a limit of the number of columns that can be pulled through, But I am only pulling "Default Channel Grouping", "Medium" and "Source" with Users and Sessions. And all sort of weirdness is happening.

Once the table has loaded I look at a specific Date in table viewer and it doesnt match what is on GA.

If i filter out that day in power query it shows the correct numbers. 

Ive tried using Source/Medium instead of individual Source and Medium to no avail.

Has anyone else seen this issue? And know how to rectify?

Not sure how I can share sample data without giving away.

Part of the power query code (this works as I have filtered out one day).

{
{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
{Cube.AddAndExpandDimensionColumn, "ga:channelGrouping", {"ga:channelGrouping"}, {"Default Channel Grouping"}},
{Cube.AddAndExpandDimensionColumn, "ga:medium", {"ga:medium"}, {"Medium"}},
{Cube.AddAndExpandDimensionColumn, "ga:source", {"ga:source"}, {"Source"}},
{Cube.AddMeasureColumn, "New Users", "ga:newUsers"},
{Cube.AddMeasureColumn, "Sessions", "ga:sessions"},
{Cube.AddMeasureColumn, "Users", "ga:users"}
}),
#"Filtered Rows" = Table.SelectRows(#"Added Items", each [Date] >= #date(2020, 3, 1)),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [Date] = #date(2021, 4, 5)) //Remove this line and the numbers will change for this day
in
#"Filtered Rows1"

Thans for the help in advance