pbi_create_import_query
Creates and injects an Excel import Power Query for a table, specifying file path, sheet, and headers.
Instructions
Generate and inject an Excel import Power Query for a table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| excel_path | Yes | ||
| sheet_name | Yes | ||
| refresh_after | No | ||
| partition_name | No | ||
| promote_headers | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |