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