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.
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 | |||