This is an old revision of the document!
Table of Contents
POWER BI COMMAND
Category: Workflow / App/Cloud
Description
This action triggers an action in the Power BI Service remotely. A configured Power BI connector is required.
Capabilities
- List workspaces
- List datasets
- Refresh dataset
- Delete all table rows
- List dataflows
- Refresh dataflow
- Export report to file
Action settings
| Setting | Description |
|---|---|
| Connector* | Select the preconfigured Power BI connector, or, build one by selecting Add connector. See Power BI connector for details. |
| Command | Select the command this action will perform. Options: List workspaces, List datasets, Refresh dataset, Delete all table rows, List dataflows, or Refresh dataflow. See below for details of each command type. |
* Setting can be specified using a parameter.
List workspaces
Description: Obtain a list of workspaces. There are no settings for this command.
List datasets
Description: Obtain a list of datasets and their attributes either in the private workspace, or in the specified shared workspace.
| Setting | Description |
|---|---|
| Workspace* | Enter or select the workspace to retrieve the list of datasets from. |
* Setting can be specified using a parameter.
Refresh dataset
Description: Refresh a dataset either from the private workspace or from the specified shared workspace. Note that only regular datasets can be refreshed using this command. Push-datasets created by the "Export to Power BI" action can't be updated because they don't have a data source specified in the Power BI Service.
| Setting | Description |
|---|---|
| Workspace* | Enter or select the workspace to retrieve the list of datasets from. |
| Dataset* | Enter or select the dataset to refresh. |
| Notify | Select a notification option for this command. Options: On success/failure, On failure only, or Do not notify. |
* Setting can be specified using a parameter.
Delete all table rows
Description: Delete all table rows in specified dataset.
| Setting | Description |
|---|---|
| Workspace* | Enter or select the workspace to retrieve the list of datasets from. |
| Dataset* | Enter or select the dataset to refresh. |
| If the dataset doesn't exist | Select how EasyMorph handles situations when the specified dataset is not found. Options: Do nothing (nothing happens, the workflow continues, no error is displayed) or Halt project execution (the workflow stops and an error is displayed). |
| Table name* | Select the table within the selected dataset to delete rows from. |
| If the table doesn't exist | Select how EasyMorph handles situations when the specified table is not found. Options: Do nothing (nothing happens, the workflow continues, no error is displayed) or Halt project execution (the workflow stops and an error is displayed). |
* Setting can be specified using a parameter.
List dataflows
Description: Returns a list of all dataflows from the specified workspace.
| Setting | Description |
|---|---|
| Workspace* | Enter or select the workspace to retrieve the list of dataflows from. |
* Setting can be specified using a parameter.
Refresh dataflow
Description: Triggers the specified dataflow.
| Setting | Description |
|---|---|
| Workspace* | Enter or select the workspace the dataflow resides in. |
| Dataset* | Enter or select the dataflow to refresh. |
| Notify | Select a notification option for this command. Options: On failure only or Do not notify. |
* Setting can be specified using a parameter.
Export report to file
Description: Exports a Power BI report to a PDF/PPTX/PNG file.
| Setting | Description |
|---|---|
| Workspace* | Enter or select the workspace the report resides in. |
| Report | Select the report to export to a file. |
| Save as | Select the file type to be exported. Options: PDF, PPTX, PNG. |
| File path* | Enter or browse to the path where the file will be saved. |
| If the file already exists | Select how EasyMorph will handle situations when a file with the same name already exists in the save location. Options: Fail (workflow stops, an error is displayed), Overwrite (the existing file is overwritten), Do nothing (nothing happens, the workflow continues, no error is displayed). |
| Filters | Optionally, enter filters on the report to export. Filter components: Table, Field and Value. See below for details of each filter component. Note: multiple filters can be added. |
| Export timeout | Select the number of minutes after which the export will fail automatically if it's not completed by then. |
| Mode | Options: All pages, Selected pages* (select a specific page from the PowerBI report to export) |
* Setting can be specified using a parameter or the first value of a column.
Filter components
| Setting | Description |
|---|---|
| Table* | Enter the table of the filter. |
| Field* | Enter the field of the filter. |
| Value* | Enter the value(s) to filter by. Options: Can have multiple values (if the "Value" box can hold multiple values with a separator, check this option, as well as selecting the separator). This allows to filter by multiple values using a single "Value" box. |
* Setting can be specified using a parameter or the first value of a column.