In this article
Overview
Use this Snap to create a new dataset, update the metadata and schema for the specified table within the specified dataset , and add new data rows to the specified table within the specified dataset in the 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 entity and/or table to create or update. |
| Output | Document |
|
| A document containing the success/failure confirmation of the push operation along with details of the impacted dataset/table. |
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 Push Dataset | Update Dataset |
| Workspace | String | Required. Enter the workspace from which to read the resource. Alternatively, click the | N/A | Employee Records |
| Entity type | String | Required. Select the entity type to read. Available options are:
| Post Dataset | Post Rows |
| Entity id | String | Required if you select the Post Rows or Put Tables option in the Entity type field. Enter the ID of the dataset in which to modify the table's metadata or to add rows in the tables. Alternatively, click the | N/A | SalesMarketingDataset (XXXXXXXXXXXXX) or XXXXXXXXXXXXX |
| Table name | String | Required if you select the Post Rows or Put Tables option in the Entity type field. Enter the name of the target table. Alternatively, click the | N/A | Designations |
| 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. |
| HTTP Response Exception:409 | Conflict | Verify the network and Snap settings. |
Invalid input. | Your input in the Get object field is invalid. | Verify whether you have entered it correctly. Alternatively, select it from the drop-down list to avoid any human errors. |
Property value is missing. | Your input for 'Workspace'/'Entity id' is missing. | Required fields cannot be blank. Verify whether you have configured all required fields correctly. |
Examples
Creating a New Dataset
We want to create a new dataset with its own set of records in the workspace. This Pipeline demonstrates how we can use the Power BI Push Dataset Snap to accomplish this task.
First, we prepare the data that we want to include inside the intended dataset. To do so, we use a JSON Generator Snap. We configure the JSON Generator Snap with all the fields and values as required. The screenshot below shows a preview of the output from the JSON Generator Snap.
Since the JSON Generator Snap's output above may not match the field names expected by Power BI, we use a Mapper Snap to map the fields properly.
Finally, we connect the Power BI Push Dataset Snap to the Mapper Snap's output. We configure the Power BI Push Dataset Snap to create a dataset in the specified workspace as shown below:
Upon successful execution, the Power BI Push Dataset Snap creates a new dataset with the included tables in the specified workspace.
The remaining portion of the Pipeline is optional. We can choose to write the Power BI Post Snap's output into a local file. To this end, we use a combination of the JSON Formatter and File Writer Snaps.
Downloads
Important steps to successfully reuse Pipelines
- Download and import the Pipeline into SnapLogic.
- Configure Snap accounts as applicable.
- Provide Pipeline parameters as applicable.
