Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jasonyeung87
Helper V
Helper V

The name 'Table.GenerateByPage' wasn't recognized

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

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler ,

 

thanks for the clarification. 

 

Sincerely,

 

Jason

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.