Deterministic Power BI audit
Exact objects captured through the Python MCP audit. This page reports the access boundary; it does not infer that unobserved estate objects are absent.
6
Tables
25
Columns
4
Measures
3
Relationships
Open Power BI Desktop model through Modeling MCP
table
| Qualified name | Parent | Observed properties | Evidence |
|---|---|---|---|
| Account | Model | Inspect 4 properties{
"columnCount": 3,
"name": "Account",
"partitionCount": 1,
"storageMode": "Import"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/tables/data/0'} |
| Calendar | Model | Inspect 4 properties{
"columnCount": 3,
"name": "Calendar",
"partitionCount": 1,
"storageMode": "Import"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/tables/data/1'} |
| DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56 | Model | Inspect 7 properties{
"columnCount": 7,
"hierarchyCount": 1,
"isHidden": true,
"isPrivate": true,
"name": "DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56",
"partitionCount": 1,
"storageMode": "Import"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/tables/data/4'} |
| Ledger | Model | Inspect 4 properties{
"columnCount": 4,
"name": "Ledger",
"partitionCount": 1,
"storageMode": "Import"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/tables/data/2'} |
| LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31 | Model | Inspect 7 properties{
"columnCount": 7,
"hierarchyCount": 1,
"isHidden": true,
"name": "LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31",
"partitionCount": 1,
"showAsVariationsOnly": true,
"storageMode": "Import"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/tables/data/5'} |
| Metrics | Model | Inspect 5 properties{
"columnCount": 1,
"measureCount": 4,
"name": "Metrics",
"partitionCount": 1,
"storageMode": "Import"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/tables/data/3'} |
column
| Qualified name | Parent | Observed properties | Evidence |
|---|---|---|---|
| Account.AccountKey | Account | Inspect 4 properties{
"dataType": "Int64",
"name": "AccountKey",
"summarizeBy": "None",
"tableName": "Account"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/0/columns/0'} |
| Account.AccountName | Account | Inspect 4 properties{
"dataType": "String",
"name": "AccountName",
"summarizeBy": "None",
"tableName": "Account"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/0/columns/1'} |
| Account.AccountType | Account | Inspect 4 properties{
"dataType": "String",
"name": "AccountType",
"summarizeBy": "None",
"tableName": "Account"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/0/columns/2'} |
| Calendar.Date | Calendar | Inspect 5 properties{
"dataType": "DateTime",
"formatString": "yyyy-mm-dd",
"name": "Date",
"summarizeBy": "None",
"tableName": "Calendar"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/1/columns/1'} |
| Calendar.DateKey | Calendar | Inspect 4 properties{
"dataType": "Int64",
"name": "DateKey",
"summarizeBy": "None",
"tableName": "Calendar"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/1/columns/0'} |
| Calendar.FiscalMonth | Calendar | Inspect 4 properties{
"dataType": "Int64",
"name": "FiscalMonth",
"summarizeBy": "Sum",
"tableName": "Calendar"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/1/columns/2'} |
| DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56.Date | DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56 | Inspect 6 properties{
"dataType": "DateTime",
"formatString": "General Date",
"isHidden": true,
"name": "Date",
"summarizeBy": "None",
"tableName": "DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/4/columns/0'} |
| DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56.Day | DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56 | Inspect 7 properties{
"dataType": "Int64",
"formatString": "0",
"isCalculated": true,
"isHidden": true,
"name": "Day",
"summarizeBy": "None",
"tableName": "DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/4/columns/6'} |
| DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56.Month | DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56 | Inspect 6 properties{
"dataType": "String",
"isCalculated": true,
"isHidden": true,
"name": "Month",
"summarizeBy": "None",
"tableName": "DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/4/columns/3'} |
| DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56.MonthNo | DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56 | Inspect 7 properties{
"dataType": "Int64",
"formatString": "0",
"isCalculated": true,
"isHidden": true,
"name": "MonthNo",
"summarizeBy": "None",
"tableName": "DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/4/columns/2'} |
| DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56.Quarter | DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56 | Inspect 6 properties{
"dataType": "String",
"isCalculated": true,
"isHidden": true,
"name": "Quarter",
"summarizeBy": "None",
"tableName": "DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/4/columns/5'} |
| DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56.QuarterNo | DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56 | Inspect 7 properties{
"dataType": "Int64",
"formatString": "0",
"isCalculated": true,
"isHidden": true,
"name": "QuarterNo",
"summarizeBy": "None",
"tableName": "DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/4/columns/4'} |
| DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56.Year | DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56 | Inspect 7 properties{
"dataType": "Int64",
"formatString": "0",
"isCalculated": true,
"isHidden": true,
"name": "Year",
"summarizeBy": "None",
"tableName": "DateTableTemplate_4a3e593b-a196-4a2f-9343-f7dc0519ce56"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/4/columns/1'} |
| Ledger.AccountKey | Ledger | Inspect 4 properties{
"dataType": "Int64",
"name": "AccountKey",
"summarizeBy": "None",
"tableName": "Ledger"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/2/columns/1'} |
| Ledger.DateKey | Ledger | Inspect 4 properties{
"dataType": "Int64",
"name": "DateKey",
"summarizeBy": "None",
"tableName": "Ledger"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/2/columns/0'} |
| Ledger.IsAdjustment | Ledger | Inspect 4 properties{
"dataType": "Boolean",
"name": "IsAdjustment",
"summarizeBy": "None",
"tableName": "Ledger"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/2/columns/3'} |
| Ledger.SignedAmount | Ledger | Inspect 5 properties{
"dataType": "Decimal",
"formatString": "$#,0.00;($#,0.00)",
"name": "SignedAmount",
"summarizeBy": "Sum",
"tableName": "Ledger"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/2/columns/2'} |
| LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31.Date | LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31 | Inspect 6 properties{
"dataType": "DateTime",
"formatString": "General Date",
"isHidden": true,
"name": "Date",
"summarizeBy": "None",
"tableName": "LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/5/columns/0'} |
| LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31.Day | LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31 | Inspect 7 properties{
"dataType": "Int64",
"formatString": "0",
"isCalculated": true,
"isHidden": true,
"name": "Day",
"summarizeBy": "None",
"tableName": "LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/5/columns/6'} |
| LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31.Month | LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31 | Inspect 6 properties{
"dataType": "String",
"isCalculated": true,
"isHidden": true,
"name": "Month",
"summarizeBy": "None",
"tableName": "LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/5/columns/3'} |
| LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31.MonthNo | LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31 | Inspect 7 properties{
"dataType": "Int64",
"formatString": "0",
"isCalculated": true,
"isHidden": true,
"name": "MonthNo",
"summarizeBy": "None",
"tableName": "LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/5/columns/2'} |
| LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31.Quarter | LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31 | Inspect 6 properties{
"dataType": "String",
"isCalculated": true,
"isHidden": true,
"name": "Quarter",
"summarizeBy": "None",
"tableName": "LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/5/columns/5'} |
| LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31.QuarterNo | LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31 | Inspect 7 properties{
"dataType": "Int64",
"formatString": "0",
"isCalculated": true,
"isHidden": true,
"name": "QuarterNo",
"summarizeBy": "None",
"tableName": "LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/5/columns/4'} |
| LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31.Year | LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31 | Inspect 7 properties{
"dataType": "Int64",
"formatString": "0",
"isCalculated": true,
"isHidden": true,
"name": "Year",
"summarizeBy": "None",
"tableName": "LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/5/columns/1'} |
| Metrics.Placeholder | Metrics | Inspect 4 properties{
"dataType": "String",
"name": "Placeholder",
"summarizeBy": "None",
"tableName": "Metrics"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/columns/data/3/columns/0'} |
measure
| Qualified name | Parent | Observed properties | Evidence |
|---|---|---|---|
| Metrics.Actual Net | Metrics | Inspect 4 properties{
"description": "Deterministic fixture total. Expected 110000.00.",
"formatString": "$#,0.00;($#,0.00)",
"name": "Actual Net",
"tableName": "Metrics"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/measures/data/0/measures/0'} |
| Metrics.Actual Revenue | Metrics | Inspect 4 properties{
"description": "Deterministic fixture total. Expected 310000.00.",
"formatString": "$#,0.00;($#,0.00)",
"name": "Actual Revenue",
"tableName": "Metrics"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/measures/data/0/measures/1'} |
| Metrics.Budget Net | Metrics | Inspect 4 properties{
"description": "Deterministic fixture constant for metadata and DAX smoke testing.",
"formatString": "$#,0.00;($#,0.00)",
"name": "Budget Net",
"tableName": "Metrics"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/measures/data/0/measures/2'} |
| Metrics.Net Variance | Metrics | Inspect 4 properties{
"description": "Deterministic fixture variance. Expected 2000.00.",
"formatString": "$#,0.00;($#,0.00)",
"name": "Net Variance",
"tableName": "Metrics"
} | ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e {'kind': 'json_pointer', 'pointer': '/inventory/measures/data/0/measures/3'} |
Lineage
Calendar.Date → LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31.Date
{
"crossFilteringBehavior": "OneDirection",
"fromCardinality": "Many",
"fromColumn": "Date",
"fromTable": "Calendar",
"isActive": true,
"name": "5beaf11a-44f7-458d-8b92-4560c1f572c7",
"toCardinality": "One",
"toColumn": "Date",
"toTable": "LocalDateTable_88a1fec1-b827-4666-af6e-18472a67bc31"
}Ledger.AccountKey → Account.AccountKey
{
"crossFilteringBehavior": "OneDirection",
"fromCardinality": "Many",
"fromColumn": "AccountKey",
"fromTable": "Ledger",
"isActive": true,
"name": "00000000-0000-0000-0000-000000000020",
"toCardinality": "One",
"toColumn": "AccountKey",
"toTable": "Account"
}Ledger.DateKey → Calendar.DateKey
{
"crossFilteringBehavior": "OneDirection",
"fromCardinality": "Many",
"fromColumn": "DateKey",
"fromTable": "Ledger",
"isActive": true,
"name": "00000000-0000-0000-0000-000000000010",
"toCardinality": "One",
"toColumn": "DateKey",
"toTable": "Calendar"
}