Power BI Delete
- Kalpana Malladi
- Mohammed Iqbal
- Gouri Bhagchandani
In this article
Overview
Use this Snap to delete the specified data resource from a selected workspace.
Prerequisites
None.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
None.
Known Issues
None.
Snap Input and Output
| Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
|---|---|---|---|---|
| Input | Document |
|
| A document containing details of the data resource to delete. |
| Output | Document |
|
| A document containing the API response from the server indicating whether the delete operation was a success. |
Snap Settings
| Parameter Name | Data Type | Description | Default Value | Example |
|---|---|---|---|---|
| Label | String | Specify a name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline. | Power BI Delete | Delete Employee Record |
| Workspace | String | Required. Enter the workspace from which to delete the resource. Alternatively, click the | My Workspace | Employee Records |
| Entity type | String | Required. Select the entity type to delete. Available options are:
| Dataset | Report |
| Entity operation | String | Select the delete operation to perform. The available options vary upon your configuration of the Entity type field. Alternatively, you can also enter the operation's name manually. Available options are:
| N/A | Delete Dataset |
| Connection details | Use this field set to configure the network connection parameters. This field set consists of the following fields:
| |||
Connection timeout | Integer | Required. Specify the connection timeout duration in seconds. | 0 | 30 |
Number of retries | Integer | Required. Specify the maximum number of re-connections if the connection fails or is timed-out. | 10 | 4 |
Retry interval (seconds) | Integer | Required. Specify the interval in seconds between reconnections. | 10 | 30 |
| Snap Execution | String | Specifies the execution type:
| Execute only | Validate & Execute |
Troubleshooting
| Error | Reason | Resolution |
|---|---|---|
| HTTP Response Exception:400 | Invalid OAuth endpoint/token URL. | Verify the values of the OAuth2 endpoint or token URLs in the account settings. |
| HTTP Response Exception:401 | Invalid refresh token or access token. | Verify the values of the refresh or access tokens in the account settings. |
Examples
Deleting Dataset from a Workspace
We want to delete the dataset named SalesMarketing from the workspace My Workspace. This Pipeline demonstrates how we can use the Power BI Read and Power BI Delete Snaps to accomplish this task:
We must first pass the target entity's ID to the Power BI Delete Snap. To do so, we use the Power BI Read Snap and configure it to read the SalesMarketing dataset in the My Workspace workspace as shown below:
We configure a Mapper Snap to pass the Entity id from the Power BI Read Snap's output to the Power BI Delete Snap as shown below:
Finally, we configure the Power BI Delete Snap to delete the Dataset entity type from the My Workspace workspace.
Upon successful execution, the Power BI Snap deletes the specified entity from the workspace and displays a confirmation as shown below:
We then write the above confirmation into a local file using a combination of the JSON Formatter and File Writer Snaps. This step is optional and you may choose to omit it.
Downloads
Important steps to successfully reuse Pipelines
- Download and import the Pipeline into SnapLogic.
- Configure Snap accounts as applicable.
- Provide Pipeline parameters as applicable.
Snap Pack History
See Also
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.