LLM Prompt Templates
Click to copy prompt + selected M code
Each template copies the selected queries from the Code tab together with the prompt text.
Known Limitations
- Dependency detection is static text analysis and may miss dynamic/computed query references.
- The graph links query-to-query references only when both queries exist in uploaded files.
File.Contents(...)andFolder.Contents(...)are normalized to base names (for example,Sales.xlsx) from full paths.- Only literal string paths in
File.Contents/Folder.Contentsare detected. - If different folders contain the same base file name, cross-file hints can be ambiguous.
- Cross-file hints are informational only and are not executable links.
- The tool extracts M script text only; it does not execute M code or validate credentials/connections.
- Very unusual DataMashup/customXml variants may fail to parse.
.xlsx,.pbix, and.pbitfiles are supported. Other formats (e.g..xls,.xlsm) are not.- V3
.pbixfiles with compressed DataModel are supported via built-in XPress9 decompression (WASM). Very large files (>100MB) may be slow to decompress.
Drop an .xlsx file to preview worksheet data
Ctrl+A Select all
Ctrl+C Copy selected
Esc Reset