read_table_offline
Extract up to 1,000 rows from a table in a closed .pbix file by briefly opening Power BI Desktop, returning columns, rows, and a truncation flag when the cap is hit.
Instructions
Read up to topN rows of one table from a CLOSED .pbix (EVALUATE TOPN(topN, 'table')). Briefly opens the file in the local Power BI Desktop (a Desktop window appears), reads the rows, then closes Desktop. Returns columns + rows; when the row cap is hit the result flags truncated:true.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| topN | No | max rows to return (default 1000) | |
| table | Yes | table name to read | |
| pbixPath | Yes | path to the closed .pbix |