Skip to main content
Extracts Azure Power BI contents from a Power BI server to the file system.  This operation supports both standard and package-based projects.
Objects can be exported in .pbix or PBIP structures, based on project properties .

Target Properties

Property Name

Property Code

Required

Description

Azure Power BI Account

FDPBI_ACCOUNT_CODE

No

The account from where we will export the files

Azure Power BI Workspace ID

FDPBI_TGT_WORKSPACE_ID

No

Workspace Id of the Power BI content

Azure Power BI Workspace Name

FDPBI_TGT_WORKSPACE_NAME

No

Workspace Name of the Power BI content. (Workspace Name is case-sensitive)

Read Timeout

FDPBI_TGT_READ_TIMEOUT

No

Timeout to get response during large file export. Default: 500 seconds. Only applicable for .pbix.

Use Default Script

FDPBI_TGT_USE_DEFAULT_SCRIPT

No

Check if you want to use the Default Script to export PBIP Files. (Keep it checked for Linux Endpoint).

Unchecking will download the latest Script from Microsoft. Recommended unchecking for Windows.

(For Windows, you can keep it unchecked, if it stops working, you can check it)

@Since 9.0.0.3

PowerShell Path

FDPBI_TGT_PWSH_PATH

No

PowerShell Path on the endpoint. (Only works with PowerShell 7 and above) Applicable for PBIP files.

@Since 9.0.0.3

Project Properties

Property Name

Property Code

Required

Description

Power BI File Format

FDPBI_FILE_FORMAT

No

The File Format specifying the type of file to save. Drop down will show PBIX and PBIP. Default is PBIX. If the project is dealing with export of PBIP type files, please select accordingly.

NOTE: When you are discovering from backend as Power BI, this property also controls how the files will be discovered to be enlisted in File Catalog.

Inputs

Input Name

Input Code

Required

Description

Power BI Account

FDPBI_INP_ACCOUNT_CODE

No

The account from where we will export the files

Reports Names

FDPBI_INP_REPORTS_NAMES

No

Comma separated list of the Report names to be exported. If nothing is provided, all reports present in the workspace will be exported as per the selected format in FDPBI_FILE_FORMAT.

Path To Export

FDPBI_INP_EXPORT_PATH

No

The directory where the exported .pbix/PBIP files will be kept. By default, it could be a folder with FD_PROJECT_NAME inside FD_TEMP_DIR.

Semantic Model Save Option

FDPBI_INP_MODEL_SAVE_OPTION

No

Format in which you want to save the Semantic Model. By default, it will be TMDL. Only applicable for PBIP.

  • TMDL

  • TMSL

@Since 9.0.0.3

Artifacts

This operation produces artifacts that will be stored in the artifacts repository.

Endpoint Selection

This operation delegates the selection to the workflow developer to determine.

Endpoint Execution

This operations delegates the execution to the workflow developer to decide.

Troubleshooting

While exporting a LIVE report, that points to another workspace’s shared semantic model, you can come across the error -
This usually means the service principal is not assigned with Contributor access to the shared semantic model’s workspace as well. Both the report and model’s workspaces need the Contributor access.
In case of .pbix, Power BI REST API doesn’t support exporting a Shared Dataset directly using the dataset id, however it can still be exported by using it’s tagged Report’s id in the workspace.To achieve this, prepare an empty report with the same name as the Dataset, and it will get exported as .pbix