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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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. 


Follow on LinkedIn
@ 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. 


Follow on LinkedIn
@ 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.