Power BI Post Import

Power BI Post Import

In this article

Overview

Use this Snap to create new records in the selected workspace from pbix, Excel, and Rdl files or OneDrive for Business.

Prerequisites

None.

Support for Ultra Pipelines

Works in Ultra Pipelines

Limitations

  • Only supports import of PBIX files less that 1 GB

  • Does not support importing PBIX files from OneDrive.

Known Issues

None.

Snap Input and Output

Input/Output

Type of View

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input/Output

Type of View

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Binary

  • Min: 1

  • Max: 1

  • File Reader

  • Mapper Snap

  • Copy Snap

  • JSON Generator

A binary stream containing details of the file or data to import.

Output

Document

  • Min: 0

  • Max: 1

  • Mapper Snap

  • Copy Snap

A document containing the success/failure confirmation. 

Snap Settings

Parameter Name

Data Type

Description

Default Value

Example 

Parameter Name

Data Type

Description

Default Value

Example 

Label

String

Power BI Post Import

Import Employee Files

Workspace

String

Required. Enter the workspace in which to import the data/file. Alternatively, click the 

 icon to fetch a list of workspaces associated with the Power BI account and select the workspace. 

My Workspace

Employee Records

Entity type

String

Required. Select the entity type to import.

Available options are:

  • Import FileImport a .pbix file from the local machine to a specific workspace. Only supports import of .pbix files less that 1 GB

  • Import from OneDrive: Import a file from OneDrive to a specific workspace.  Does not support importing PBIX files from OneDrive.

Import File

Import from OneDrive

Dataset display name

String

Specify the dataset's name to use after importing data from the file. The name must also include the file's extension.

Not supported when importing from OneDrive.

N/A

PowerUserTraining

Skip report

Check box

Select to skip report importOnly supported for PBIX files.

Not selected 

Selected

Name conflict

String

Specify how to handle creating a dataset when a dataset of the same name exists already.

Available options are:

Only Abort and Overwrite are supported for RDL files.

Ignore

Abort

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

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:

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

Validate & Execute

Troubleshooting

Error

Reason

Resolution

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.