Forum Discussion
List.Generate - Connect to REST API without Total Number of Pages and Total Number of Entries
I got it... i got it... i'm sooooooo happy.
= List.Generate(
() => [PAGE = 1, RESULTS = GetPageClientes("1")],
each Table.RowCount(Table.SelectRows([RESULTS], each [count]>0)) >0,
each [PAGE = [PAGE] + 1, RESULTS = GetPageClientes(Number.ToText([PAGE] + 1))],
each [RESULTS])My research was that:
https://www.dalesandro.net/handling-paginated-rest-api-results-with-power-query/
https://www.thebiccountant.com/2020/05/15/miss-last-page-paging-power-bi-power-query/
https://www.youtube.com/watch?v=05yhwnuCjRw
https://www.youtube.com/watch?v=IASH1Fr16HY
Hi Anonymous ,
that really is an annoying behaviour. Please check out this blogpost where I've described a workaraound: How not to miss the last page when paging with Power BI and Power Query (thebiccountant.com)