Powerbi Authoring Cli

# How to Retrieve Semantic Model Properties

Semantic model properties are spread across **three distinct API surfaces** due to gaps in the Fabric API. This guide maps each property category to the correct retrieval method.

For authentication, variable setup, and audience details, see [SKILL.md § Authentication & API Audiences](../SKILL.md#authentication--api-audiences).

---

## Property-to-API Mapping

| Property Category | API Surface | Endpoint Pattern | SKILL.md Section |
|---|---|---|---|
| Name, ID, Description, Type | Fabric Items | `GET .../semanticModels/{id}` | [Agentic Workflow](../SKILL.md#agentic-workflow) step 2 |
| Owner, Storage Mode, Created Date | Power BI Datasets | `GET .../datasets/{id}` | — (see [below](#owner-storage-mode--operational-metadata)) |
| Query Scale-Out Settings | Power BI Datasets | `GET .../datasets/{id}` | — (see [below](#owner-storage-mode--operational-metadata)) |
| Full TMDL Schema | Fabric Items | `POST .../semanticModels/{id}/getDefinition?format=TMDL` | [Get/Download Definition](../SKILL.md#getdownload-definition) |
| Refresh History & Status | Power BI Datasets | `GET .../datasets/{id}/refreshes` | [Refresh Operations](../SKILL.md#refresh-operations) |
| Refresh Execution Details | Power BI Datasets | `GET .../datasets/{id}/refreshes/{refreshId}` | — (see [below](#refresh-history-response-properties)) |
| Refresh Schedule (Import) | Power BI Datasets | `GET .../datasets/{id}/refreshSchedule` | [Refresh Operations](../SKILL.md#refresh-operations) |
| Refresh Schedule (DirectQuery/LiveConnection) | Power BI Datasets | `GET .../datasets/{id}/directQueryRefreshSchedule` | — (see [below](#directquery--liveconnection-refresh-schedule)) |
| Data Sources | Power BI Datasets | `GET .../datasets/{id}/datasources` | [Data Sources & Parameters](../SKILL.md#data-sources--parameters) |
| Gateway Data Sources | Power BI Datasets | `GET .../datasets/{id}/Default.GetBoundGatewayDatasources` | — |
| Discoverable Gateways | Power BI Datasets | `GET .../datasets/{id}/Default.DiscoverGateways` | — |
| Parameters | Power BI Datasets | `GET .../datasets/{id}/parameters` | [Data Sources & Parameters](../SKILL.md#data-sources--parameters) |
| Permissions | Power BI Datasets | `GET .../datasets/{id}/users` | [Permissions](../SKILL.md#permissions) |
| Upstream Dataflow Links | Power BI Datasets | `GET .../datasets/upstreamDataflows` | — (see [below](#upstream-dataflow-links)) |
| Query Scale-Out Sync Status | Power BI Datasets | `GET .../datasets/{id}/queryScaleOut/syncStatus` | — |
| Tables, Columns, Measures | TMDL Definition | Decode `definition/tables/*.tmdl` parts | [TMDL File Structure](../SKILL.md#tmdl-file-structure) |
| Relationships | TMDL Definition | Decode `definition/relationships.tmdl` part | [TMDL File Structure](../SKILL.md#tmdl-file-structure) |
| M Expressions / Connections | TMDL Definition | Decode `definition/expressions*` parts | [TMDL File Structure](../SKILL.md#tmdl-file-structure) |

---

## Owner, Storage Mode & Operational Metadata

These properties are **only available** via the Power BI Datasets API — the Fabric Items API does not expose them.

```bash
az rest --method get \
  --resource "https://analysis.windows.net/powerbi/api" \
  --url "$PBI/groups/$WS_ID/datasets/$MODEL_ID"
```

**Properties returned**:

| Property | Description |
|---|---|
| `configuredBy` | Owner / last configured by (user principal name) |
| `createdDate` | ISO 8601 creation timestamp |
| `targetStorageMode` | `Abf` (Direct Lake), `PremiumFiles` (Import on Fabric), `Import` |
| `isRefreshable` | Whether the model supports refresh (always `false` for DirectQuery/LiveConnection) |
| `isEffectiveIdentityRequired` | RLS requires effective identity in embed scenarios |
| `isEffectiveIdentityRolesRequired` | RLS roles must be specified |
| `isOnPremGatewayRequired` | On-premises gateway needed for data sources |
| `isInPlaceSharingEnabled` | Whether the dataset can be shared with external users to consume in