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/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
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 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 Post ImportImport Employee Files
WorkspaceString

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 WorkspaceEmployee Records
Entity typeString

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 FileImport from OneDrive
Dataset display nameString

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/APowerUserTraining
Skip reportCheck boxSelect to skip report importOnly supported for PBIX files.Not selected Selected
Name conflictString

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

Available options are:

    • Abort: Aborts the operation.
    • CreateOrOverwrite: Overwrites existing dataset. The operation fails if there are more than one datasets with the same name. 
    • GenerateUniqueName: Generates a unique name for the dataset.
    • IgnoreCreates a new dataset with the same name.
    • OverwriteOverwrites the existing dataset with the new one. The operation fails if there is no conflict or if there are more than one datasets with the same name.

Only Abort and Overwrite are supported for RDL files.

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

Examples

Importing PBIX File

We want to import a PBIX file from the SnapLogic Database (SLDB) into the specified workspace. This Pipeline demonstrates how we can use the Power BI Post Import Snap to accomplish this task.

Since the file to import is in the SLDB, we use the File Reader Snap to read the file. We then add the Power BI Post Import Snap and configure it as shown below:

Upon successful execution, the Power BI Post Import Snap imports the PBIX file into the workspace and outputs a confirmation of the successful import.

The remaining portion of the Pipeline is optional. We can choose to write the Power BI Post Import 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_POST_IMPORT_Import_PBIX_File.slp

Mar 02, 2022 by Subhajit Sengupta

Snap Pack History

 Click here to expand...

Release

Snap Pack Version 

Date

Type

Updates

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:


See Also