profile_table
Profiles a loaded Power BI table for blanks, duplicates, constant or truncated columns, placeholder dates, and row-count mismatches to catch data-quality issues before analysis.
Instructions
Data-quality profile of one loaded table: per column blanks, distinct
count, min/max, longest text; flags entirely-blank / constant columns,
text at a truncation limit (30/255...), placeholder dates (1900/9999).
key_columns checks duplicates and blank keys; expected_row_count
(e.g. COUNT(*) you ran on the source) flags a mismatch.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"instance": "<instance>",
"table": "<table>"
},
"name": "profile_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| columns | No | ||
| instance | Yes | ||
| key_columns | No | ||
| max_columns | No | ||
| expected_row_count | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||