Forum Discussion
how to create a query that paginates?
Community ChampionYes, unfortunately there are 2 different types of errors and you seem to have got those who "infect" their neighborhood. Hard to come up with workarounds without actually getting my hands on it. My only suggestion is to reduce the transformations within List.Generate to the minimum (as suggested in one of my previous posts) and trying to circumnavigate the errors after that.
Does your WebCall actually return the data in the table-format that you've shown in your pic or is that the result of a further transformation-step already?
re 2) If you can transform the list to a table (like you've done) it should be possible to remove its last item instead. What does:
List.Range(Pagination, 0, List.Count(Pagination)-1)
return (instead of your current step "Converted to Table")?
Helper I1) I think I mentioned it but it was lost in the long comment - the change you previously suggested gives a ''We cannot convert a value of type List to type Table.' error. I've been trying the same idea but I am not sure what else to cut out (also because I'm only at 75% understanding on how the whole query works - I don't understand some of the little details what they do)
2)errors out altogether - I've just noticed now but even though 'converted to table' works, when i click on the 'Pagination' step, the name is 'Error':
would it work to add an error check statement in this part of the query :
each Table.RowCount([Table])>0 or [Counter]=0 + or [Table] is error? I already tried to remove last row from Table = Table.FromRecords(WebCall[events]) but it doesn't do anything at all
Thanks for the effort!