read_query_result
Retrieve paginated results from Power BI DAX queries saved as CSV files. Use offset and limit parameters to efficiently access large datasets without exceeding context limits.
Instructions
Read a page of rows from a CSV file saved by execute_dax.
Use this tool when execute_dax returns a savedTo path instead of
inline rows. Combine offset and limit to page through large results
without loading the entire file into context.
Returns rows for the requested slice together with pagination metadata:
totalRows: total number of rows in the file
offset: the offset used
limit: the limit used
hasMore: whether more rows exist after this page
Example workflow:
Call
execute_dax— if rows > 50 you get a savedTo path.Call
read_query_result(file_path=savedTo, offset=0, limit=100).If hasMore is true, call again with offset=100, then 200, etc.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| offset | No | ||
| limit | No |