PatrickGallucci/fabric-skills

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- **Access**: Fabric workspace Contributor or Admin role - **Tools**: PowerShell 7+, Fabric REST API access (Microsoft Entra token) - **Endpoints**: `https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items`

- **Tools**: PowerShell 7+, Fabric REST API access (Microsoft Entra token) - **Endpoints**: `https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items` - **Monitoring**: Access to Fabric Admin Portal and Azure Cost Analysis

- **Endpoints**: `https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items`

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

# Check workspace items to understand workload mix $items = Invoke-RestMethod `     -Uri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items" `

$items = Invoke-RestMethod      -Uri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items"

-Uri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items" `

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

$workspace = Invoke-RestMethod `     -Uri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId" `

-Uri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId" `

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances?jobType=TableMaintenance

Executable file

.NOTES     Requires: Az.Accounts module, authenticated Azure session (Connect-AzAccount)     API Base: https://api.fabric.microsoft.com/v1

API Base: https://api.fabric.microsoft.com/v1

try {     $tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

$tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

$apiBase = "https://api.fabric.microsoft.com/v1"

Executable file

try {     $tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

$tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$LakehouseId/jobs/instances?jobType=TableMaintenance"

Executable file

try {     $tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

$tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

$apiBase = "https://api.fabric.microsoft.com/v1"

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Publishing and Sharing](./references/publishing-and-sharing.md) - Publish, share, and consume data agents - [External Integration](./references/external-integration.md) - Azure AI Foundry, Copilot Studio, Teams integration - [Microsoft L

- [External Integration](./references/external-integration.md) - Azure AI Foundry, Copilot Studio, Teams integration - [Microsoft Learn: Create a Fabric data agent](https://learn.microsoft.com/en-us/fabric/data-science/how-to-create-data-ag

- [Microsoft Learn: Create a Fabric data agent](https://learn.microsoft.com/en-us/fabric/data-science/how-to-create-data-agent)

- [Microsoft Learn: Data agent concepts](https://learn.microsoft.com/en-us/fabric/data-science/concept-data-agent)

- [Microsoft Learn: Tenant settings](https://learn.microsoft.com/en-us/fabric/data-science/data-agent-tenant-settings)

- [Microsoft Learn: Data agent SDK](https://learn.microsoft.com/en-us/fabric/data-science/fabric-data-agent-sdk)

- [Microsoft Learn: Evaluate your data agent](https://learn.microsoft.com/en-us/fabric/data-science/evaluate-data-agent)

5. Test queries across different question phrasings 6. Use the "steps" dropdown in responses to see generated queries and debug 7. Evaluate programmatically using the [Fabric Data Agent Python SDK](https://learn.microsoft.com/en-us/fabric/d

7. Evaluate programmatically using the [Fabric Data Agent Python SDK](https://learn.microsoft.com/en-us/fabric/data-science/evaluate-data-agent)

Executable file

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

$results.Add((New-CheckResult -Category 'Environment' -Check 'PowerShell Version' `         -Status 'Warning' -Message "PowerShell $psVersion detected. 7+ recommended." `         -Remediation 'Install PowerShell 7+: https://learn.microsoft.

-Status 'Warning' -Message "PowerShell $psVersion detected. 7+ recommended." `         -Remediation 'Install PowerShell 7+: https://learn.microsoft.com/powershell/scripting/install/installing-powershell')) }

-Remediation 'Install PowerShell 7+: https://learn.microsoft.com/powershell/scripting/install/installing-powershell'))

[Credential-related source omitted]

[Credential-related source omitted]

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId"

[Credential-related source omitted]

[Credential-related source omitted]

$itemsUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items"

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Operations Agent Schema](./references/operations-agent-schema.md) — REST API definition structure (Configurations.json) - [Foundry Integration](./references/foundry-integration.md) — Connecting Fabric Data Agents with Azure AI Foundry - 

- [Foundry Integration](./references/foundry-integration.md) — Connecting Fabric Data Agents with Azure AI Foundry - [Microsoft Learn: Create a Fabric data agent](https://learn.microsoft.com/en-us/fabric/data-science/how-to-create-data-agen

- [Microsoft Learn: Create a Fabric data agent](https://learn.microsoft.com/en-us/fabric/data-science/how-to-create-data-agent)

- [Microsoft Learn: Data agent configuration](https://learn.microsoft.com/en-us/fabric/data-science/data-agent-config)

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

Executable file

.EXAMPLE     .\Invoke-FabricFoundryAgent.ps1 `         -ProjectEndpoint "https://myproject.services.ai.azure.com/api" `

.\Invoke-FabricFoundryAgent.ps1          -ProjectEndpoint "https://myproject.services.ai.azure.com/api"

-ProjectEndpoint "https://myproject.services.ai.azure.com/api" `

Write-Host '[1/6] Authenticating...' -ForegroundColor Cyan $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://cognitiveservices.azure.com'

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://cognitiveservices.azure.com'

Executable file

Connect-AzAccount | Out-Null     }     $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com'

[Credential-related source omitted]

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com'

$baseUri = 'https://api.fabric.microsoft.com/v1'

Write-Host "      Item ID      : $itemId" Write-Host "      Display Name : $AgentName" Write-Host "      Portal URL   : https://app.fabric.microsoft.com/groups/$WorkspaceId/items/$itemId"

Write-Host "      Display Name : $AgentName" Write-Host "      Portal URL   : https://app.fabric.microsoft.com/groups/$WorkspaceId/items/$itemId" Write-Host ''

Write-Host "      Portal URL   : https://app.fabric.microsoft.com/groups/$WorkspaceId/items/$itemId"

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Fabric Data Factory Pipeline Troubleshoot Guide](https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-troubleshoot-guide)

- [Copy Activity Performance and Scalability Guide](https://learn.microsoft.com/en-us/fabric/data-factory/copy-activity-performance-and-scalability-guide)

- [Copy Activity Performance with SQL Databases](https://learn.microsoft.com/en-us/fabric/data-factory/copy-performance-sql-databases)

- [Monitor Pipeline Runs](https://learn.microsoft.com/en-us/fabric/data-factory/monitor-pipeline-runs)

Executable file

[Credential-related source omitted]

[Credential-related source omitted]

$baseUrl = "https://api.fabric.microsoft.com/v1"

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Get-DataflowHealthReport.ps1](./scripts/Get-DataflowHealthReport.ps1) — Workspace health audit - [Watch-DataflowRefresh.ps1](./scripts/Watch-DataflowRefresh.ps1) — Real-time refresh monitor - [Microsoft Learn: Best Practices for Dataflow

- [Watch-DataflowRefresh.ps1](./scripts/Watch-DataflowRefresh.ps1) — Real-time refresh monitor - [Microsoft Learn: Best Practices for Dataflow Gen2 Performance](https://learn.microsoft.com/en-us/fabric/data-factory/dataflow-gen2-performance

- [Microsoft Learn: Best Practices for Dataflow Gen2 Performance](https://learn.microsoft.com/en-us/fabric/data-factory/dataflow-gen2-performance-best-practices)

- [Microsoft Learn: Fast Copy in Dataflow Gen2](https://learn.microsoft.com/en-us/fabric/data-factory/dataflows-gen2-fast-copy)

- [Microsoft Learn: View Refresh History and Monitor Dataflows](https://learn.microsoft.com/en-us/fabric/data-factory/dataflows-gen2-monitor)

- [Microsoft Learn: Dataflow Gen2 Pricing](https://learn.microsoft.com/en-us/fabric/data-factory/pricing-dataflows-gen2)

[Credential-related source omitted]

[Credential-related source omitted]

https://api.fabric.microsoft.com/v1

$workspaceId = "<workspace-id>" $uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/dataflows"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/dataflows"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/dataflows/$dataflowId/refresh"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items/$dataflowId/jobs/instances"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items"

$workspaces = (Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces" -Headers $headers).value

foreach ($ws in $workspaces) {         try {             $dfs = (Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces/$($ws.id)/dataflows" -Headers $headers).value

try {             $dfs = (Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces/$($ws.id)/dataflows" -Headers $headers).value             foreach ($df in $dfs) {

$dfs = (Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces/$($ws.id)/dataflows" -Headers $headers).value

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/dataflows/$DataflowId/getDefinition"

$metaJson = [System.Text.Encoding]::UTF8.GetString([Convert]::FromBase64String($metaPart.payload))

# Trigger refresh     $refreshUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/dataflows/$DataflowId/refresh"

$refreshUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/dataflows/$DataflowId/refresh"

do {         Start-Sleep -Seconds $PollIntervalSeconds         $jobsUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$DataflowId/jobs/instances"

Start-Sleep -Seconds $PollIntervalSeconds         $jobsUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$DataflowId/jobs/instances"         $jobs = (Invoke-RestMethod -Uri $jobsUri -Headers $Headers).value

$jobsUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$DataflowId/jobs/instances"

Executable file

Set-StrictMode -Version Latest $ErrorActionPreference = "Stop" $baseUri = "https://api.fabric.microsoft.com/v1"

$baseUri = "https://api.fabric.microsoft.com/v1"

function Get-FabricHeaders {     try {         $tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com" -ErrorAction Stop

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com" -ErrorAction Stop         return @{

$tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com" -ErrorAction Stop

[Convert]::FromBase64String($metaPart.payload)

Executable file

Set-StrictMode -Version Latest $ErrorActionPreference = "Stop" $baseUri = "https://api.fabric.microsoft.com/v1"

$baseUri = "https://api.fabric.microsoft.com/v1"

function Get-FabricHeaders {     try {         $tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com" -ErrorAction Stop

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com" -ErrorAction Stop         return @{

$tokenResponse = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com" -ErrorAction Stop

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances?jobType=TableMaintenance

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances/{operationId}

Executable file

Executable file

Executable file

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Prereq Validation Script](./scripts/Validate-FabricIQPrereqs.ps1) - [Ontology Template](./templates/ontology-design-template.md) - [Microsoft Learn: Fabric IQ Overview](https://learn.microsoft.com/en-us/fabric/iq/overview)

- [Ontology Template](./templates/ontology-design-template.md) - [Microsoft Learn: Fabric IQ Overview](https://learn.microsoft.com/en-us/fabric/iq/overview) - [Microsoft Learn: Ontology Overview](https://learn.microsoft.com/en-us/fabric/iq/

- [Microsoft Learn: Fabric IQ Overview](https://learn.microsoft.com/en-us/fabric/iq/overview)

- [Microsoft Learn: Ontology Overview](https://learn.microsoft.com/en-us/fabric/iq/ontology/overview)

- [Sample Data: IQ Samples on GitHub](https://github.com/microsoft/fabric-samples/tree/main/docs-samples/iq)

[Credential-related source omitted]

[Credential-related source omitted]

$workspaceId = "your-workspace-id" $uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items?type=Ontology"

$itemId = "your-ontology-item-id" $uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items/$itemId"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items/$itemId"

| **Minimum SKU** | F2 or P1 (paid SKUs only) | | **Trial SKU** | Not supported for Copilot features | | **Region** | Capacity must be in a supported region ([Fabric region availability](https://learn.microsoft.com/en-us/fabric/admin/region

| **Region** | Capacity must be in a supported region ([Fabric region availability](https://learn.microsoft.com/en-us/fabric/admin/region-availability)) |

| Issue | Cause | Solution | |-------|-------|----------| | 401 Unauthorized | Token expired or wrong audience | Get a fresh token with `Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"` |

|-------|-------|----------| | 401 Unauthorized | Token expired or wrong audience | Get a fresh token with `Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"` | | 403 Forbidden | Insufficient workspace permissions | Ensure A

| 401 Unauthorized | Token expired or wrong audience | Get a fresh token with `Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"` |

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items?type=Ontology"

# Check if a lakehouse table is accessible for ontology binding $lhUri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items?type=Lakehouse"

$lhUri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items?type=Lakehouse"

If you encounter issues not covered here, submit suggestions to [Fabric Ideas](https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas) using the label **IQ | Ontology**.

Executable file

function Get-FabricToken {     try {         $tokenResult = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com" -ErrorAction Stop

try {         $tokenResult = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com" -ErrorAction Stop         return $tokenResult.Token

$tokenResult = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com" -ErrorAction Stop

if (-not $WorkspaceId) {     $workspaces = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces" -Headers $headers

$workspaces = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces" -Headers $headers

} else {     $ws = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId" -Headers $headers

else {     $ws = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId" -Headers $headers     if ($ws) {

$ws = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId" -Headers $headers

Write-Host "--- Ontology Tenant Setting ---" -ForegroundColor White     $ontologyItems = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=Ontology" -Headers $headers

$ontologyItems = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=Ontology" -Headers $headers

Write-Host ""     Write-Host "--- Data Agent Tenant Setting (Optional) ---" -ForegroundColor White     $agentItems = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=DataAgent" -Headers $headers

Write-Host "--- Data Agent Tenant Setting (Optional) ---" -ForegroundColor White     $agentItems = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=DataAgent" -Headers $headers     if ($null -ne 

$agentItems = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=DataAgent" -Headers $headers

Write-Host ""     Write-Host "--- Data Sources ---" -ForegroundColor White     $lakehouses = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=Lakehouse" -Headers $headers

Write-Host "--- Data Sources ---" -ForegroundColor White     $lakehouses = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=Lakehouse" -Headers $headers     if ($lakehouses -and $lakehouses.value

$lakehouses = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=Lakehouse" -Headers $headers

$eventhouses = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=Eventhouse" -Headers $headers

$semanticModels = Invoke-FabricApi -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=SemanticModel" -Headers $headers

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [SQL Endpoint Security Reference](./references/sql-endpoint-security-reference.md) — T-SQL granular permissions, RLS, CLS, OLS, dynamic data masking - [Direct Lake Security Integration](./references/direct-lake-security-reference.md) — Pe

- [Direct Lake Security Integration](./references/direct-lake-security-reference.md) — Permission models, OLS/RLS interaction, remediate matrix - [Microsoft Learn: OneLake Security Overview](https://learn.microsoft.com/en-us/fabric/onelake/

- [Microsoft Learn: OneLake Security Overview](https://learn.microsoft.com/en-us/fabric/onelake/security/get-started-security)

- [Microsoft Learn: SQL Granular Permissions](https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-granular-permissions)

- [Microsoft Learn: Best Practices for OneLake Security](https://learn.microsoft.com/en-us/fabric/onelake/security/best-practices-secure-data-in-onelake)

Executable file

Executable file

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

$roleAssignments = Invoke-RestMethod `         -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/roleAssignments" `

-Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/roleAssignments" `

try {     $lakehouse = Invoke-RestMethod `         -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/lakehouses/$LakehouseId" `

$lakehouse = Invoke-RestMethod          -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/lakehouses/$LakehouseId"

-Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/lakehouses/$LakehouseId" `

$defUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/lakehouses/$LakehouseId/getDefinition"

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances?jobType=TableMaintenance

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances/{operationId}

[Credential-related source omitted]

[Credential-related source omitted]

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items/$lakehouseId/jobs/instances"

- Microsoft Entra token for Fabric service - Fabric REST API endpoint: `https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items`

- Fabric REST API endpoint: `https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items`

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances?jobType=TableMaintenance

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances/{operationId}

[Credential-related source omitted]

[Credential-related source omitted]

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items/$lakehouseId/jobs/instances?jobType=TableMaintenance"

Executable file

function Get-FabricToken {     try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com'

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com'         return $tokenResponse.Token

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com'

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/lakehouses/$LakehouseId"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/lakehouses/$LakehouseId/tables"

Executable file

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com'

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com'

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$LakehouseId/jobs/instances?jobType=TableMaintenance"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$LakehouseId/jobs/instances/$OperationId"

Executable file

Executable file

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances/{jobInstanceId}

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

[Credential-related source omitted]

[Credential-related source omitted]

# Download latest Azure IP ranges and service tags $downloadUrl = 'https://www.microsoft.com/download/details.aspx?id=56519'

$downloadUrl = 'https://www.microsoft.com/download/details.aspx?id=56519'

- A compute resource with internet access (local machine, Azure VM, or WSL) - Download the Fabric Runtime setup file from the [Fabric Runtime GitHub repo](https://github.com/microsoft/fabric-runtime) matching your Runtime version

- Download the Fabric Runtime setup file from the [Fabric Runtime GitHub repo](https://github.com/microsoft/fabric-runtime) matching your Runtime version

[Credential-related source omitted]

[Credential-related source omitted]

$response = Invoke-RestMethod `     -Uri 'https://api.fabric.microsoft.com/v1/admin/workspaces/networkingCommunicationPolicies' `

-Uri 'https://api.fabric.microsoft.com/v1/admin/workspaces/networkingCommunicationPolicies' `

Executable file

- [Fabric Network Security Overview](https://learn.microsoft.com/en-us/fabric/security/security-overview)

- [Managed VNets](https://learn.microsoft.com/en-us/fabric/security/security-managed-vnets-fabric-overview)

- [Managed Private Endpoints](https://learn.microsoft.com/en-us/fabric/security/security-managed-private-endpoints-overview)

- [Fabric URL Allowlist](https://learn.microsoft.com/en-us/fabric/security/fabric-allow-list-urls)

- [Service Tags](https://learn.microsoft.com/en-us/fabric/security/security-service-tags)

- [Workspace Outbound Access Protection](https://learn.microsoft.com/en-us/fabric/security/workspace-outbound-access-protection-overview)

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

Executable file

Executable file

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

# Instead of global endpoint: # https://onelake.dfs.fabric.microsoft.com/...

# https://onelake.dfs.fabric.microsoft.com/...

# Use region-specific endpoint: $region = "westus"  # Match your capacity region $endpoint = "https://$region-onelake.dfs.fabric.microsoft.com"

$endpoint = "https://$region-onelake.dfs.fabric.microsoft.com"

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances?jobType=TableMaintenance

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances/{operationId}

Executable file

try {         $tokenResponse = Get-AzAccessToken -AsSecureString -ResourceUrl "https://api.fabric.microsoft.com"

$tokenResponse = Get-AzAccessToken -AsSecureString -ResourceUrl "https://api.fabric.microsoft.com"

$baseUri = "https://api.fabric.microsoft.com/v1"

Write-Host "`n--- OneLake Endpoint Connectivity ---" -ForegroundColor White $globalEndpoint = "https://onelake.dfs.fabric.microsoft.com"

$globalEndpoint = "https://onelake.dfs.fabric.microsoft.com"

if ($Region) {     $regionalEndpoint = "https://$Region-onelake.dfs.fabric.microsoft.com"

$regionalEndpoint = "https://$Region-onelake.dfs.fabric.microsoft.com"

Executable file

function Get-OneLakeToken {     try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://storage.azure.com' -ErrorAction Stop

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://storage.azure.com' -ErrorAction Stop         return $tokenResponse.Token

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://storage.azure.com' -ErrorAction Stop

$baseUrl = "https://$($parsed.Account)/$($parsed.Container)/$($parsed.FilePath)"

Executable file

function Get-FabricAccessToken {     try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop         return $tokenResponse.Token

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

$submitUrl = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$LakehouseId/jobs/instances?jobType=TableMaintenance"

$statusUrl = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$LakehouseId/jobs/instances/$operationId"

Executable file

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

$workspaceUrl = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId"

$itemsUrl = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items"

Executable file

function Get-FabricAccessToken {     try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop         return $tokenResponse.Token

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

$tablesUrl = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/lakehouses/$LakehouseId/tables"

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

comment syntax for the file format. Please also get the specific       language for your license from:       http://www.apache.org/licenses/LICENSE-2.0

http://www.apache.org/licenses/LICENSE-2.0

http://www.apache.org/licenses/LICENSE-2.0

Executable file

[Credential-related source omitted]

[Credential-related source omitted]

"Content-Type"  = "application/json"     }     $uri = "https://api.fabric.microsoft.com/v1$Endpoint"

}     $uri = "https://api.fabric.microsoft.com/v1$Endpoint"     try {

$uri = "https://api.fabric.microsoft.com/v1$Endpoint"

Executable file

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [DirectQuery Tuning](./references/directquery-tuning.md) - Source optimization and Composite models - [Performance Report Template](./templates/performance-report-template.md) - Audit documentation template - [Microsoft: Optimization guid

- [Performance Report Template](./templates/performance-report-template.md) - Audit documentation template - [Microsoft: Optimization guide for Power BI](https://learn.microsoft.com/en-us/power-bi/guidance/power-bi-optimization) - [Microsof

- [Microsoft: Optimization guide for Power BI](https://learn.microsoft.com/en-us/power-bi/guidance/power-bi-optimization)

- [Microsoft: Troubleshoot report performance](https://learn.microsoft.com/en-us/power-bi/guidance/report-performance-troubleshoot)

- [Microsoft: Monitor report performance](https://learn.microsoft.com/en-us/power-bi/guidance/monitor-report-performance)

- [Microsoft: Evaluate and optimize Fabric capacity](https://learn.microsoft.com/en-us/fabric/enterprise/optimize-capacity)

Executable file

Write-Step "Checking Power BI authentication..."     try {         Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/me" -Method Get | Out-Null

try {         Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/me" -Method Get | Out-Null     }

Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/me" -Method Get | Out-Null

$body = $daxQuery | ConvertTo-Json -Depth 5     $url = "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId/datasets/$DatasetId/executeQueries"

$url = "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId/datasets/$DatasetId/executeQueries"

$datasetInfo = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId/datasets/$DatasetId" -Method Get | ConvertFrom-Json

Executable file

Write-Step "Checking Power BI authentication..."     try {         $profile = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/me" -Method Get | ConvertFrom-Json

try {         $profile = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/me" -Method Get | ConvertFrom-Json         Write-Host "  Authenticated as: $($profile.displayName)" -ForegroundColor Green

$profile = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/me" -Method Get | ConvertFrom-Json

Write-Step "Retrieving workspace details..."     $workspace = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId" -Method Get | ConvertFrom-Json

$workspace = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId" -Method Get | ConvertFrom-Json

Write-Step "Retrieving semantic models..."     $datasets = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId/datasets" -Method Get | ConvertFrom-Json

$datasets = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId/datasets" -Method Get | ConvertFrom-Json

Write-Host "    Retrieving refresh history..." -ForegroundColor Gray             try {                 $refreshes = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId/datasets/$($ds.id)/refreshes?`$top=10"

$refreshes = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId/datasets/$($ds.id)/refreshes?`$top=10" -Method Get | ConvertFrom-Json

Write-Step "Retrieving reports..."     $reports = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId/reports" -Method Get | ConvertFrom-Json

$reports = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$WorkspaceId/reports" -Method Get | ConvertFrom-Json

- [Optimization guide for Power BI](https://learn.microsoft.com/en-us/power-bi/guidance/power-bi-optimization)

- [Troubleshoot report performance](https://learn.microsoft.com/en-us/power-bi/guidance/report-performance-troubleshoot)

- [Monitor report performance](https://learn.microsoft.com/en-us/power-bi/guidance/monitor-report-performance)

- [Evaluate and optimize Fabric capacity](https://learn.microsoft.com/en-us/fabric/enterprise/optimize-capacity)

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Sensitivity Labels Guide](./references/sensitivity-labels-guide.md) — Label configuration and issues - [XMLA & API Access Guide](./references/xmla-api-access.md) — Service principal and endpoint access - [Microsoft Learn: Security in Fab

- [XMLA & API Access Guide](./references/xmla-api-access.md) — Service principal and endpoint access - [Microsoft Learn: Security in Fabric](https://learn.microsoft.com/en-us/fabric/security/security-overview) - [Microsoft Learn: Permission

- [Microsoft Learn: Security in Fabric](https://learn.microsoft.com/en-us/fabric/security/security-overview)

- [Microsoft Learn: Permission Model](https://learn.microsoft.com/en-us/fabric/security/permission-model)

- [Microsoft Learn: RLS with Power BI](https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security)

- [Microsoft Learn: OLS](https://learn.microsoft.com/en-us/fabric/security/service-admin-object-level-security)

- [Microsoft Learn: Troubleshoot Access Restrictions](https://learn.microsoft.com/en-us/fabric/governance/troubleshoot-restricted-access)

Executable file

Executable file

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Capacity Health Reference](./references/capacity-health-reference.md) - REST API schemas and interpretation - [Cost Analysis Reference](./references/cost-analysis-reference.md) - Autoscale vs capacity billing comparison - [Fabric Capacit

- [Cost Analysis Reference](./references/cost-analysis-reference.md) - Autoscale vs capacity billing comparison - [Fabric Capacity Metrics App](https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app) - [Monitor Spark Capacity Consu

- [Fabric Capacity Metrics App](https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app)

- [Monitor Spark Capacity Consumption](https://learn.microsoft.com/en-us/fabric/data-engineering/monitor-spark-capacity-consumption)

- [Fabric REST API Documentation](https://learn.microsoft.com/en-us/rest/api/microsoftfabric/)

- [Concurrency Limits and Queueing](https://learn.microsoft.com/en-us/fabric/data-engineering/spark-job-concurrency-and-queueing)

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Fabric/capacities?api-version=2023-11-01

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Fabric/capacities/{capacityName}?api-version=2023-11-01

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{itemId}/jobs/instances

[Credential-related source omitted]

$items = (Invoke-RestMethod -Method Get -Uri "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items" -Headers $headers).value

Executable file

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

$apiVersion = '2023-11-01' $baseUri = "https://management.azure.com/subscriptions/$SubscriptionId/resourceGroups/$ResourceGroupName/providers/Microsoft.Fabric/capacities"

$baseUri = "https://management.azure.com/subscriptions/$SubscriptionId/resourceGroups/$ResourceGroupName/providers/Microsoft.Fabric/capacities"

Executable file

.NOTES     Requires: Fabric API access token     API Base: https://api.fabric.microsoft.com/v1

Requires: Fabric API access token     API Base: https://api.fabric.microsoft.com/v1     Job statuses: NotStarted, InProgress, Completed, Failed, Cancelled

API Base: https://api.fabric.microsoft.com/v1

[Credential-related source omitted]

[Credential-related source omitted]

$fabricApiBase = 'https://api.fabric.microsoft.com/v1'

Executable file

.NOTES     Requires: Fabric API access token with Workspace.Read.All scope     API Base: https://api.fabric.microsoft.com/v1

API Base: https://api.fabric.microsoft.com/v1

[Credential-related source omitted]

[Credential-related source omitted]

$fabricApiBase = 'https://api.fabric.microsoft.com/v1'

Executable file

try {     $armToken = (Get-AzAccessToken -ResourceUrl 'https://management.azure.com').Token

$armToken = (Get-AzAccessToken -ResourceUrl 'https://management.azure.com').Token

$fabricToken = (Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com').Token

$capUri = "https://management.azure.com/subscriptions/$SubscriptionId/resourceGroups/$ResourceGroupName/providers/Microsoft.Fabric/capacities/$($CapacityName)?api-version=2023-11-01"

$wsUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId"

$itemsUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items"

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

Executable file

Executable file

Executable file

Executable file

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

|-------|---------| | `Workspace.ReadWrite.All` | Manage workspace properties | | `https://api.fabric.microsoft.com/.default` | Request all statically assigned permissions (service principal flows) |

| `https://api.fabric.microsoft.com/.default` | Request all statically assigned permissions (service principal flows) |

POST https://login.microsoftonline.com/{tenantId}/oauth2/v2.0/token

[Credential-related source omitted]

[Credential-related source omitted]

scope=https://api.fabric.microsoft.com/.default

# Cancel an in-progress publish POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/environments/{artifactId}/staging/cancelPublish

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/environments/{artifactId}/staging/cancelPublish

Executable file

if ($TenantId -and $ClientId -and $ClientSecret) {     $tokenResult = Measure-Operation -Name "Token Acquisition" -Count $Iterations -Operation {         $tokenUri = "https://login.microsoftonline.com/$TenantId/oauth2/v2.0/token"

$tokenResult = Measure-Operation -Name "Token Acquisition" -Count $Iterations -Operation {         $tokenUri = "https://login.microsoftonline.com/$TenantId/oauth2/v2.0/token"         $tokenBody = @{

$tokenUri = "https://login.microsoftonline.com/$TenantId/oauth2/v2.0/token"

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

scope         = 'https://api.fabric.microsoft.com/.default'

[Credential-related source omitted]

$getResult = Measure-Operation -Name "GET /workspaces/{id}/items" -Count $Iterations -Operation {     $uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items"

$wsResult = Measure-Operation -Name "GET /workspaces/{id}" -Count $Iterations -Operation {     $uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId"

$listWsResult = Measure-Operation -Name "GET /workspaces (first page)" -Count $Iterations -Operation {     $uri = "https://api.fabric.microsoft.com/v1/workspaces"

$uri = "https://api.fabric.microsoft.com/v1/workspaces"

$paginateResult = Measure-Operation -Name "Paginated Items (all pages)" -Count ([math]::Min($Iterations, 3)) -Operation {     $uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items"

Executable file

Write-Host "Creating test notebook to trigger LRO..."     $createUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/notebooks"

$createUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/notebooks"

Executable file

$baseUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items"

Executable file

$items = Invoke-FabricPaginatedApi `         -InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$wsId/items" `

-InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$wsId/items" `

$match = Invoke-FabricPaginatedApi `         -InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$wsId/items" `

-InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$wsId/items" `

# # Enumerate all items # $result = Invoke-FabricPaginatedApi ` #     -InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items" `

# $result = Invoke-FabricPaginatedApi  #     -InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items"

#     -InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items" `

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

Structured diagnostic workflows for identifying and resolving errors when calling Microsoft Fabric REST APIs (`https://api.fabric.microsoft.com/v1/`).

[System.Convert]::FromBase64String($payload)

Fabric REST APIs use scopes in the format `https://api.fabric.microsoft.com/<Scope>`. Common scopes:

[Credential-related source omitted]

[Credential-related source omitted]

$response = Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces" `

Fabric API base: `https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items`

./scripts/Invoke-FabricApiWithRetry.ps1 `     -Uri "https://api.fabric.microsoft.com/v1/workspaces" `

-Uri "https://api.fabric.microsoft.com/v1/workspaces" `

**Step 3 — Check Fabric service health** at [Microsoft 365 Service Health](https://admin.microsoft.com/Adminportal/Home#/servicehealth) or [Azure Status](https://status.azure.com/).

Two approaches: 1. Use the `Location` header URL directly (preferred) 2. Construct: `GET https://api.fabric.microsoft.com/v1/operations/{operationId}`

2. Construct: `GET https://api.fabric.microsoft.com/v1/operations/{operationId}`

If the operation has a result, append `/result` to the operation URL: `GET https://api.fabric.microsoft.com/v1/operations/{operationId}/result`

`GET https://api.fabric.microsoft.com/v1/operations/{operationId}/result`

$allItems = @() $uri = "https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items"

│   ├── Check DNS resolution for api.fabric.microsoft.com │   ├── Verify no proxy/firewall blocking HTTPS │   └── Test with: Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/"

│   ├── Verify no proxy/firewall blocking HTTPS │   └── Test with: Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/" └── Token acquisition failed?

│   └── Test with: Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/"

$clientId   = "<your-app-client-id>" $tenantId   = "<your-tenant-id>" $scopes     = @("https://api.fabric.microsoft.com/Workspace.ReadWrite.All",

$tenantId   = "<your-tenant-id>" $scopes     = @("https://api.fabric.microsoft.com/Workspace.ReadWrite.All",                 "https://api.fabric.microsoft.com/Item.ReadWrite.All")

$scopes     = @("https://api.fabric.microsoft.com/Workspace.ReadWrite.All",

"https://api.fabric.microsoft.com/Item.ReadWrite.All")

$tokenResult = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

scope         = "https://api.fabric.microsoft.com/.default"

$response = Invoke-RestMethod      -Method Post      -Uri "https://login.microsoftonline.com/$tenantId/oauth2/v2.0/token"

-Uri "https://login.microsoftonline.com/$tenantId/oauth2/v2.0/token" `

[Credential-related source omitted]

$tokenResult = Get-MsalToken      -ClientId $clientId      -TenantId $tenantId      -ClientCertificate (Get-PfxCertificate -FilePath $certPath -Password (ConvertTo-SecureString $certPassword -AsPlainText -Force))      -Scopes @("https://api

-TenantId $tenantId `     -ClientCertificate (Get-PfxCertificate -FilePath $certPath -Password (ConvertTo-SecureString $certPassword -AsPlainText -Force)) `     -Scopes @("https://api.fabric.microsoft.com/.default")

-Scopes @("https://api.fabric.microsoft.com/.default")

string clientId  = "YourApplicationId"; string authority = "https://login.microsoftonline.com/organizations";

string authority = "https://login.microsoftonline.com/organizations";

string redirect  = "http://localhost";

string[] scopes = new[] {     "https://api.fabric.microsoft.com/Workspace.ReadWrite.All",

"https://api.fabric.microsoft.com/Workspace.ReadWrite.All",

"https://api.fabric.microsoft.com/Item.ReadWrite.All"

string[] scopes = new[] { "https://api.fabric.microsoft.com/.default" };

.Create(clientId)     .WithClientSecret(clientSecret)     .WithAuthority($"https://login.microsoftonline.com/{tenantId}")

.WithClientSecret(clientSecret)     .WithAuthority($"https://login.microsoftonline.com/{tenantId}")     .Build();

.WithAuthority($"https://login.microsoftonline.com/{tenantId}")

[Credential-related source omitted]

[Credential-related source omitted]

new TokenRequestContext(new[] { "https://api.fabric.microsoft.com/.default" })

| Claim | Expected Value | Issue If Wrong | |-------|---------------|----------------| | `aud` | `https://api.fabric.microsoft.com` | Wrong resource/audience requested |

|-------|---------------|----------------| | `aud` | `https://api.fabric.microsoft.com` | Wrong resource/audience requested | | `iss` | `https://sts.windows.net/{tenantId}/` | Wrong tenant |

| `aud` | `https://api.fabric.microsoft.com` | Wrong resource/audience requested |

| `iss` | `https://sts.windows.net/{tenantId}/` | Wrong tenant |

1. Decode JWT payload and check `exp` claim against current time 2. Verify `aud` (audience) is `https://api.fabric.microsoft.com`

2. Verify `aud` (audience) is `https://api.fabric.microsoft.com`

2. Note the exact UTC timestamp of the failure 3. Record the full request (method, URL, headers, body) 4. Check [Microsoft 365 Service Health](https://admin.microsoft.com/Adminportal/Home#/servicehealth)

3. Record the full request (method, URL, headers, body) 4. Check [Microsoft 365 Service Health](https://admin.microsoft.com/Adminportal/Home#/servicehealth) 5. Open a support ticket with the above information

4. Check [Microsoft 365 Service Health](https://admin.microsoft.com/Adminportal/Home#/servicehealth)

# List accessible workspaces (validates authentication) Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces" `

Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces" `

# Get specific workspace (validates workspace ID) Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId" `

Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId" `

# List items in workspace (validates workspace access) Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items" `

Invoke-RestMethod -Uri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/items" `

| Header | Purpose | Example | |--------|---------|---------| | `Location` | URL for polling operation status | `https://api.fabric.microsoft.com/v1/operations/{operationId}` |

|--------|---------|---------| | `Location` | URL for polling operation status | `https://api.fabric.microsoft.com/v1/operations/{operationId}` | | `x-ms-operation-id` | Operation GUID (for constructing URLs manually) | `xxxxxxxx-xxxx-xxxx-

| `Location` | URL for polling operation status | `https://api.fabric.microsoft.com/v1/operations/{operationId}` |

GET https://api.fabric.microsoft.com/v1/operations/{operationId}

GET https://api.fabric.microsoft.com/v1/operations/{operationId}/result

if (-not $locationUrl -and $operationId) {             $locationUrl = "https://api.fabric.microsoft.com/v1/operations/$operationId"

$locationUrl = "https://api.fabric.microsoft.com/v1/operations/$operationId"

# Create a lakehouse (returns 202 for LRO) $result = Invoke-FabricLongRunningOperation `     -InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/lakehouses" `

$result = Invoke-FabricLongRunningOperation      -InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/lakehouses"

-InitialUri "https://api.fabric.microsoft.com/v1/workspaces/$workspaceId/lakehouses" `

[Credential-related source omitted]

new AuthenticationHeaderValue("Bearer", token);         _client.BaseAddress = new Uri("https://api.fabric.microsoft.com/v1/");     }

_client.BaseAddress = new Uri("https://api.fabric.microsoft.com/v1/");

Executable file

$result = ./Invoke-FabricApiWithRetry.ps1 `         -Uri "https://api.fabric.microsoft.com/v1/workspaces" `

-Uri "https://api.fabric.microsoft.com/v1/workspaces" `

$result = ./Invoke-FabricApiWithRetry.ps1 `         -Uri "https://api.fabric.microsoft.com/v1/workspaces/$wsId/items" `

-Uri "https://api.fabric.microsoft.com/v1/workspaces/$wsId/items" `

$allItems = @()     $uri = "https://api.fabric.microsoft.com/v1/workspaces/$wsId/items"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$wsId/items"

Executable file

[string]$Token,     [string[]]$Scopes = @(         "https://api.fabric.microsoft.com/Workspace.ReadWrite.All",

[string[]]$Scopes = @(         "https://api.fabric.microsoft.com/Workspace.ReadWrite.All",         "https://api.fabric.microsoft.com/Item.ReadWrite.All"

"https://api.fabric.microsoft.com/Workspace.ReadWrite.All",

"https://api.fabric.microsoft.com/Item.ReadWrite.All"

$ErrorActionPreference = 'Stop' $baseUrl = "https://api.fabric.microsoft.com/v1"

$baseUrl = "https://api.fabric.microsoft.com/v1"

try {         $response = Invoke-WebRequest -Uri "https://api.fabric.microsoft.com/v1/" `

$response = Invoke-WebRequest -Uri "https://api.fabric.microsoft.com/v1/" `

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

scope         = "https://api.fabric.microsoft.com/.default"

$tokenResponse = Invoke-RestMethod `             -Method Post `             -Uri "https://login.microsoftonline.com/$TenantId/oauth2/v2.0/token" `

-Method Post `             -Uri "https://login.microsoftonline.com/$TenantId/oauth2/v2.0/token" `             -ContentType "application/x-www-form-urlencoded" `

-Uri "https://login.microsoftonline.com/$TenantId/oauth2/v2.0/token" `

[Credential-related source omitted]

elseif (Get-Module -ListAvailable -Name Az.Accounts) {             Connect-AzAccount -TenantId $TenantId | Out-Null             $tokenResult = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

[Credential-related source omitted]

$tokenResult = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

[System.Convert]::FromBase64String($payload)

}     else {         Write-DiagResult "Token Audience" "FAIL" "aud: $($decoded.aud) (expected: https://api.fabric.microsoft.com)"

else {         Write-DiagResult "Token Audience" "FAIL" "aud: $($decoded.aud) (expected: https://api.fabric.microsoft.com)"     }

Write-DiagResult "Token Audience" "FAIL" "aud: $($decoded.aud) (expected: https://api.fabric.microsoft.com)"

Executable file

$FabricConfig = @{     BaseUrl       = "https://api.fabric.microsoft.com/v1"

BaseUrl       = "https://api.fabric.microsoft.com/v1"

# Option A: Interactive (for development)     # $result = Get-MsalToken -ClientId $clientId -TenantId $tenantId `     #     -Scopes @("https://api.fabric.microsoft.com/.default") -Interactive

# $result = Get-MsalToken -ClientId $clientId -TenantId $tenantId      #     -Scopes @("https://api.fabric.microsoft.com/.default") -Interactive

#     -Scopes @("https://api.fabric.microsoft.com/.default") -Interactive

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

#     scope         = "https://api.fabric.microsoft.com/.default"

# }     # $response = Invoke-RestMethod -Method Post `     #     -Uri "https://login.microsoftonline.com/$env:FABRIC_TENANT_ID/oauth2/v2.0/token" `

# $response = Invoke-RestMethod -Method Post      #     -Uri "https://login.microsoftonline.com/$env:FABRIC_TENANT_ID/oauth2/v2.0/token"

#     -Uri "https://login.microsoftonline.com/$env:FABRIC_TENANT_ID/oauth2/v2.0/token" `

[Credential-related source omitted]

# Option C: Az.Accounts (if already connected)     # $result = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

# $result = Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com"

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Capacity and Sizing Guide](./references/capacity-and-sizing.md) — Always-On, cache policies, CU consumption - [Workspace Monitoring Setup](./references/workspace-monitoring.md) — Enabling and using monitoring tables and dashboards - [KQL

- [Workspace Monitoring Setup](./references/workspace-monitoring.md) — Enabling and using monitoring tables and dashboards - [KQL Best Practices (Microsoft)](https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/best-practices) 

- [KQL Best Practices (Microsoft)](https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/best-practices)

- [Eventhouse Compute Observability](https://learn.microsoft.com/en-us/fabric/real-time-intelligence/eventhouse-compute-observability)

- [Eventstream Monitoring](https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/monitor)

- [Fabric Capacity Metrics App](https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app)

Available from the [fabric-toolbox GitHub repository](https://github.com/microsoft/fabric-toolbox/tree/main/monitoring/workspace-monitoring-dashboards). This dashboard provides:

1. Download the template JSON from the GitHub repository 2. Follow the [Visualize your Workspace Monitoring Data](https://learn.microsoft.com/en-us/fabric/fundamentals/sample-gallery-workspace-monitoring) guide

2. Follow the [Visualize your Workspace Monitoring Data](https://learn.microsoft.com/en-us/fabric/fundamentals/sample-gallery-workspace-monitoring) guide

Executable file

.NOTES     Requires: Az.Accounts module for authentication     Fabric REST API: https://learn.microsoft.com/en-us/rest/api/fabric/

Fabric REST API: https://learn.microsoft.com/en-us/rest/api/fabric/

[Credential-related source omitted]

[Credential-related source omitted]

[Credential-related source omitted]

$baseUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items"

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId"

if ($workspace.capacityId) {         try {             $capUri = "https://api.fabric.microsoft.com/v1/capacities/$($workspace.capacityId)"

try {             $capUri = "https://api.fabric.microsoft.com/v1/capacities/$($workspace.capacityId)"             $capacity = Invoke-FabricApi -Uri $capUri -Token $Token

$capUri = "https://api.fabric.microsoft.com/v1/capacities/$($workspace.capacityId)"

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Read Optimization (VOrder, Resource Profiles)](./references/read-optimization.md) - [General Spark Tuning Guide](./references/general-tuning.md) - [Microsoft Fabric Spark Compute Documentation](https://learn.microsoft.com/fabric/data-eng

- [General Spark Tuning Guide](./references/general-tuning.md) - [Microsoft Fabric Spark Compute Documentation](https://learn.microsoft.com/fabric/data-engineering/spark-compute) - [Delta Lake Table Optimization and V-Order](https://learn.m

- [Microsoft Fabric Spark Compute Documentation](https://learn.microsoft.com/fabric/data-engineering/spark-compute)

- [Delta Lake Table Optimization and V-Order](https://learn.microsoft.com/fabric/data-engineering/delta-optimization-and-v-order)

- [Lakehouse Table Maintenance](https://learn.microsoft.com/fabric/data-engineering/lakehouse-table-maintenance)

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances?jobType=TableMaintenance

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances/{operationId}

Executable file

if (-not $AccessToken) {     try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop         $AccessToken = $tokenResponse.Token

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

$baseUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$LakehouseId"

Executable file

if (-not $AccessToken) {     try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop         $AccessToken = $tokenResponse.Token

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

try {     $capacityUri = "https://api.fabric.microsoft.com/v1/admin/capacities/$CapacityId"

$capacityUri = "https://api.fabric.microsoft.com/v1/admin/capacities/$CapacityId"

Executable file

if (-not $AccessToken) {     try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

try {         $tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop         $AccessToken = $tokenResponse.Token

$tokenResponse = Get-AzAccessToken -ResourceUrl 'https://api.fabric.microsoft.com' -ErrorAction Stop

$baseUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items/$LakehouseId"

Executable file

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

Executable file

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

- [Microsoft Fabric Spark Compute Overview](https://learn.microsoft.com/en-us/fabric/data-engineering/spark-compute)

- [Autotune for Apache Spark in Fabric](https://learn.microsoft.com/en-us/fabric/data-engineering/autotune)

- [Concurrency Limits and Queueing](https://learn.microsoft.com/en-us/fabric/data-engineering/spark-job-concurrency-and-queueing)

- [Spark Monitoring Overview](https://learn.microsoft.com/en-us/fabric/data-engineering/spark-monitoring-overview)

- [Delta Lake Table Optimization and V-Order](https://learn.microsoft.com/en-us/fabric/data-engineering/delta-optimization-and-v-order)

- [Resource Profile Configurations](https://learn.microsoft.com/en-us/fabric/data-engineering/resource-profile-configurations)

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances?jobType=TableMaintenance

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{lakehouseId}/jobs/instances/{operationId}

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/spark/livySessions

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/notebooks/{notebookId}/livySessions

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/notebooks/{notebookId}/livySessions/{sessionId}

Executable file

.PARAMETER Token     Bearer token for Fabric REST API authentication.     Obtain via: (Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com").Token

Obtain via: (Get-AzAccessToken -ResourceUrl "https://api.fabric.microsoft.com").Token

.NOTES     Requires: PowerShell 7+     API Reference: https://learn.microsoft.com/en-us/fabric/data-engineering/spark-monitoring-api-overview

API Reference: https://learn.microsoft.com/en-us/fabric/data-engineering/spark-monitoring-api-overview

$baseUri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId"

Executable file

Apache License                            Version 2.0, January 2004                         http://www.apache.org/licenses/

http://www.apache.org/licenses/

http://www.apache.org/licenses/LICENSE-2.0

Check current region availability at [Fabric region availability](https://learn.microsoft.com/en-us/fabric/admin/region-availability).

- [Diagnostic Checklist Script](./scripts/diagnostic-checklist.ps1) - Interactive remediate walkthrough - [Performance Logging Template](./templates/perf_logging.py) - Instrumented function boilerplate - [Microsoft Docs: View Function Logs]

- [Performance Logging Template](./templates/perf_logging.py) - Instrumented function boilerplate - [Microsoft Docs: View Function Logs](https://learn.microsoft.com/en-us/fabric/data-engineering/user-data-functions/view-function-logs) - [Mi

- [Microsoft Docs: View Function Logs](https://learn.microsoft.com/en-us/fabric/data-engineering/user-data-functions/view-function-logs)

- [Microsoft Docs: Service Limits](https://learn.microsoft.com/en-us/fabric/data-engineering/user-data-functions/user-data-functions-service-limits)

- [Microsoft Docs: Fabric Operations](https://learn.microsoft.com/en-us/fabric/enterprise/fabric-operations)

- [Microsoft Docs: Capacity Metrics App](https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app)

Executable file

[Credential-related source omitted]

[Credential-related source omitted]

$uri = "https://api.fabric.microsoft.com/v1/workspaces/$WorkspaceId/items?type=UserDataFunction"

Executable file

Executable file