Expression Error: The name ‘List.Split wasn’t recognised.

Hi Edderlyna,

This is quite strange... Can you try using the List.Split in a different environment? E.g. in Excel if you do it in PBI and vise versa?

The List.Split can be replaced with something like this:

fListSplit = (list, pageSize) => List.Accumulate({0..Number.RoundUp(List.Count(list) / pageSize) - 1}, {}, (a, n)=> a & {List.Range(list,  n * pageSize, pageSize)})

And then you just call it fListSplit rather than List.Split. It will do the same thing. But this is quite strange. List.Split works Ok in my PQ.

Cheers,

John