Power BI Push Dataset

Owned by Kalpana Malladi
Last updated: Jun 03, 2024 by Kalpana Malladi
4 min read

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/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
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 DatasetUpdate Dataset
WorkspaceString

Required. Enter the workspace from which to read the resource. Alternatively, click the  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 dataset in the workspace.
  • Post Rows: Alters the metadata of a specific table under a designated dataset.
  • Put Tables: Adds rows to a specific table under a designated dataset.
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 to modify the table's metadata or to add rows to the tables. Alternatively, click the  icon to fetch the IDs of all datasets available in the workspace. 

This field is shown dynamically according to different entity types from the suggestions. Users are allowed to choose an entity id from the suggestion or type an entity manually. The entity is shown as "[dataset name]  ([dataset id])" in the suggestions. But it is also allowed to type only [dataset id] in this field.

In order to get table name suggestions, you have to select the dataset id. 

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  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

Troubleshooting

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. 

Examples

Create a New Dataset

This example pipeline demonstrates how to create a new dataset with its own set of records in the workspace.

 

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.

Download this pipeline.

Downloads

Important 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.

  File Modified

File Example_PowerBI_Push_Dataset_Push_Sales_Marketing_DataSet.slp

Mar 02, 2022 by Subhajit Sengupta

Snap Pack History

 Click here to expand...

Release

Snap Pack Version 

Date

Type

Updates

May 2024main172 StableUpdated and certified against the current SnapLogic Platform release.
February 2024main168 StableUpdated and certified against the current SnapLogic Platform release.
November 2023main155StableUpdated and certified against the current SnapLogic Platform release.

August 2023

main138

Stable

Updated and certified against the current SnapLogic Platform release.

May 2023

main130 

Stable

Upgraded with the latest SnapLogic Platform release.

February 2023main114 StableUpgraded with the latest SnapLogic Platform release.
November 2022main113 StableUpgraded with the latest SnapLogic Platform release.
August 2022

main111

 StableUpgraded with the latest SnapLogic Platform release.
4.29main108 StableUpgraded with the latest SnapLogic Platform release.
4.28main100  StableUpgraded with the latest SnapLogic Platform release.
4.27main93 

Stable

Upgraded with the latest SnapLogic Platform release.
4.26main88StableUpgraded with the latest SnapLogic Platform release.
4.25main80 StableNo updates made.
4.24patchesmain80 LatestEnhanced the following Snaps in the Microsoft Power BI Snap Pack by supporting data flows with two options, Dataflow and Dataflow Storage Accounts.
4.23main76 LatestUpdated the dependencies and documentation links for all the Microsoft Power BI Snaps.

4.23

main73


Latest

Introduced the Microsoft Power BI Snap Pack that enables you to access and control entities such as datasets, reports, gateways, and dashboards in the workspace. The Microsoft Power BI Snap Pack contains the following Snaps:

Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.