Versions Compared

Old Version 8

changes.mady.by.user Amritesh Singh

Saved on

compared with

New Version Current

changes.mady.by.user Amritesh Singh

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

Table of Contents
maxLevel2
absoluteUrltrue

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

...

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
Input 

Document

  • Min: 0
  • Max: 1
  • Mapper Snap
  • Copy Snap
A document containing details of the entity and/or table to create or update.
Output

Document

  • Min: 1
  • Max: 1
  • Mapper Snap
  • Copy Snap
A document containing the success/failure confirmation of the push operation along with details of the impacted dataset/table.

Snap Settings

Parameter NameData TypeDescriptionDefault ValueExample 
LabelString
Insert excerpt
File Writer
File Writer
nopaneltrue
Power BI Push DatasetUpdate Dataset
WorkspaceString

Required. Enter the workspace from which to read the resource. Alternatively, click the Image Modified icon to fetch a list of workspaces associated with the Power BI account and select the workspace. 

N/AEmployee Records
Entity typeString

Required. Select the entity type to read.

Available options are:

  • Post Dataset: Creates a new dataset in the workspace.
  • Post Rows: Alters the metadata of the specified table.
  • Put Tables: Adds rows in the specified table.
Post DatasetPost Rows
Entity idString

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 Image Modified icon to fetch the IDs of all datasets available in the workspace. 

N/ASalesMarketingDataset (XXXXXXXXXXXXX) or XXXXXXXXXXXXX
Table nameString

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 Image Modified icon to fetch the IDs of all tables available in the workspace. 

N/ADesignations
Connection details

Use this field set to configure the network connection parameters.

This field set consists of the following fields:

  • Connection timeout
  • Number of retries
  • Retry interval (seconds)

Connection timeout

IntegerRequired. Specify the connection timeout duration in seconds.030

Number of retries

IntegerRequired. Specify the maximum number of re-connections if the connection fails or is timed-out.104

Retry interval (seconds)

IntegerRequired. Specify the interval in seconds between reconnections.1030
Snap ExecutionString

Specifies the execution type:

  • Validate & Execute: Performs limited execution of the Snap (up to 50 records) during Pipeline validation; performs full execution of the Snap (unlimited records) during Pipeline execution.

  • Execute only: Performs full execution of the Snap during Pipeline execution; does not execute the Snap during Pipeline validation.

  • Disabled: Disables the Snap and, by extension, its downstream Snaps.

Execute onlyValidate & Execute

...

ErrorReasonResolution
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:401Invalid refresh token or access token.Verify the values of the refresh or access tokens in the account settings.
HTTP Response Exception:409ConflictVerify 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. 

...