Versions Compared

Key

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

In this article

Table of Contents
maxLevel2
absoluteUrltrue

...

Parameter NameData TypeDescriptionDefault ValueExample 
LabelString
Insert excerpt
File Writer
File Writer
nopaneltrue
Power BI UpdateUpdate Employee Record
WorkspaceString

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

My WorkspaceEmployee Records
Entity typeString

Required. Select the entity type to update.

Available options are:

  • Dataset: Collection of tables from different data sources ready for reporting and visualizations.
  • Report: Visualized interpretations, findings, and insights of a dataset. A report can include many pages.
  • Gateway: Connections between Power BI's cloud-based analysis service and on-premise data sources.
  • Dataflow: Collection of entities (tables) that you create and manage in workspaces.
DatasetReport
Entity operationString

Select the update 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.

The available options are:

  • Dataset
    • Update Datasources
    • Update Direct Query Refresh Schedule
    • Update Parameters
    • Update Refresh Schedule
  • Report
    • Update Report Content
  • Gateway
    • Update Datasource
N/AUpdate Datasources
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. 

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. 

...

Upon successful execution, the Power BI Update Snap updates the target dataset with the updated data.

Download this Pipeline.

Downloads

Note
titleImportant steps to successfully reuse Pipelines
  1. Download and import the Pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide Pipeline parameters as applicable.

...