List.ConformToPageReader
ListInternalConforms a list to a page reader table format. Intended for internal use only.
Syntax
List.ConformToPageReader(list as list, optional options as nullable record) as tableParameters
| Name | Type | Required | Description |
|---|---|---|---|
list | list | Yes | The list to conform to the page reader format. |
options | record | No | An optional record of options that control the page reader behavior. |
Return Value
table — A table representing the list data conformed to the page reader format.
Remarks
List.ConformToPageReader is an internal-only function as stated in the official Microsoft documentation. It is part of the Power Query engine's internal pagination infrastructure, used to convert a list into the engine's internal page reader table format.
### Background
The Power Query engine uses a page reader pattern internally to handle streaming and pagination of large data sets. When data is loaded from sources that provide data in pages (such as REST APIs with paginated responses), the engine uses page readers to efficiently stream data without loading everything into memory at once.
List.ConformToPageReader adapts a plain M list to this internal page reader format, making it compatible with the engine's streaming infrastructure.
### Important
This function is not intended for use in user-written M queries. For pagination patterns in user code, use:
List.Generateto implement manual pagination loops.Table.GenerateByPage(a common helper pattern) for page-by-page API consumption.- The
Web.Contentsfunction with appropriate pagination logic.
Examples
Example 1: Conceptual usage
let
// List.ConformToPageReader is used internally by the Power Query engine
// for pagination infrastructure. In user code, use List.Generate instead:
Pages = List.Generate(
() => [Page = 0, Data = GetPage(0)],
each [Data] <> null,
each [Page = [Page] + 1, Data = GetPage([Page] + 1)],
each [Data]
)
in
Pages