Get-FabricMirroredDatabaseTableStatus
Retrieves the status of tables in a mirrored database.
Syntax
Get-FabricMirroredDatabaseTableStatus [-WorkspaceId] <guid> [[-MirroredDatabaseId] <guid>]
[<CommonParameters>]Description
Retrieves the status of tables in a mirrored database. The function validates the authentication token, constructs the API endpoint URL, and makes a POST request to retrieve the mirroring status of tables. It handles errors and logs messages at various levels (Debug, Error).
Examples
Example 1
This example retrieves the status of tables in a mirrored database with the specified ID in the specified workspace.
Get-FabricMirroredDatabaseTableStatus -WorkspaceId "your-workspace-id" -MirroredDatabaseId "your-mirrored-database-id"Parameters
| Name | Type | Req. | Pos. | Pipeline | Description |
|---|---|---|---|---|---|
| -WorkspaceId | guid | ✓Required | 0 | – | The ID of the workspace containing the mirrored database. |
| -MirroredDatabaseId | guid | 1 | – | The ID of the mirrored database whose table status is to be retrieved. |
This cmdlet also supports the common parameters, such as -Verbose and -ErrorAction. See about_CommonParameters.
Outputs
System.Object[]
{{ Fill in the Description }}
Notes
The function retrieves the PowerBI access token and makes a POST request to the PowerBI API to retrieve the status of tables in the specified mirrored database. It then returns the 'value' property of the response, which contains the table statuses.
Author: Tiago Balabuch, Kamil Nowinski