Update-FabricKQLQuerysetDefinition
Updates the definition of a KQLQueryset in a Microsoft Fabric workspace.
Syntax
Update-FabricKQLQuerysetDefinition [-WorkspaceId] <guid> [-KQLQuerysetId] <guid>
[-KQLQuerysetPathDefinition] <string> [[-KQLQuerysetPathPlatformDefinition] <string>] [-WhatIf]
[-Confirm] [<CommonParameters>]Description
This function allows updating the content or metadata of a KQLQueryset in a Microsoft Fabric workspace. The KQLQueryset content can be provided as file paths, and metadata updates can optionally be enabled.
Examples
Example 1
Updates the content of the KQLQueryset with ID 67890 in the workspace 12345 using the specified KQLQueryset file.
Update-FabricKQLQuerysetDefinition -WorkspaceId "12345" -KQLQuerysetId "67890" -KQLQuerysetPathDefinition "C:\KQLQuerysets\KQLQueryset.ipynb"Example 2
Updates both the content and metadata of the KQLQueryset with ID 67890 in the workspace 12345.
Update-FabricKQLQuerysetDefinition -WorkspaceId "12345" -KQLQuerysetId "67890" -KQLQuerysetPathDefinition "C:\KQLQuerysets\KQLQueryset.ipynb"Parameters
| Name | Type | Req. | Pos. | Pipeline | Description |
|---|---|---|---|---|---|
| -KQLQuerysetId | guid | ✓Required | 1 | – | (Mandatory) The unique identifier of the KQLQueryset to be updated. |
| -KQLQuerysetPathDefinition | string | ✓Required | 2 | – | (Mandatory) The file path to the KQLQueryset content definition file. The content will be encoded as Base64 and sent in the request. |
| -WorkspaceId | guid | ✓Required | 0 | – | (Mandatory) The unique identifier of the workspace where the KQLQueryset resides. |
| -Confirmalias: cf | switch | Named | – | Prompts you for confirmation before running the cmdlet. |
|
| -KQLQuerysetPathPlatformDefinition | string | 3 | – | (Optional) The file path to the KQLQueryset's platform-specific definition file. The content will be encoded as Base64 and sent in the request. |
|
| -WhatIfalias: wi | switch | Named | – | Runs the command in a mode that only reports what would happen without performing the actions. |
This cmdlet also supports the common parameters, such as -Verbose and -ErrorAction. See about_CommonParameters.
Notes
- Calls
Confirm-TokenStateto ensure token validity before making the API request. - The KQLQueryset content is encoded as Base64 before being sent to the Fabric API.
- This function handles asynchronous operations and retrieves operation results if required.
Author: Tiago Balabuch, Kamil Nowinski