The name 'Table.GenerateByPage' wasn't recognized

[jasonyeung87]

Hi,

I have a Power BI report which accesses an API that has pagination. It would only return the first 100 records, even though there are more than 100 records that match the criteria. I did some investigation on how to grab all records from API's that have pagination. 

I found the following sample link:

https://learn.microsoft.com/en-us/power-query/samples/trippin/5-paging/readme

This uses the "Table.GenerateByPage" function (https://learn.microsoft.com/en-us/power-query/helperfunctions#tablegeneratebypage). But when I try to create a new function which calls "Table.GenerateByPage", I get the following error:

Expression.Error: The name 'Table.GenerateByPage' wasn't recognized. Make sure it's spelled correctly.

This function is part of Power Query and I may be missing a library that contains this function. I was wondering how would I include this in Power BI desktop?

Jason

[Greg_Deckler · Accepted solution]

@jasonyeung87 That table is not intended for use in Power Query Editor, it is for use in creating custom connectors. 

[jasonyeung87]

@Greg_Deckler ,

thanks for the clarification. 

Sincerely,

Jason