Overview
Script task to export Power BI report.
Setup
The script has the following parameters:
- RestConnection - Select Power BI Connection.
- Format - Select file format to export.
- IsReportIdVariable - Indicates whether the report identifier is stored in a variable.
- ReportId - Specifies report identifier.
- ReportIdVariable - Selects variable containing report identifier.
- IsPagesVariable - Indicates whether the pages to export is stored in a variable.
- Pages - Specifies report pages to export. Optional.
- PagesVariable - Selects variable containing report report pages to export.
- IsFileVariable - Indicates whether the result export file path is stored in a variable.
- File - Specifies report export path.
- FileVariable - Selects variable containing report export path.
Configuration
To use this script, you would need to load it in COZYROC JavaScript Task. If you are using COZYROC SSIS+ 2.0 or later, after selecting the corresponding script type and opening the component editor, you can select the script from a dropdown list with the pre-built scripts. For COZYROC SSIS+ 1.9, you can download the JavaScript file and browse to it via the "Import JavaScript code" button.
Power_BI_Report_Export_Task.jsKnowledge Base
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.