pbi_bulk_import_excel
Bulk create Power Query import queries from an Excel file for multiple tables, mapping sheets to table names with optional header promotion and refresh.
Instructions
Bulk-create Excel import queries for multiple tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| excel_path | Yes | ||
| refresh_after | No | ||
| promote_headers | No | ||
| sheet_table_map | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |