User Tools

Site Tools


transformations:powerbicommand

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.


Action settings

Setting Description
Connector*Select the preconfigured Power BI connector, or, build one by selecting Add connector.
See Power BI connector for details.
CommandSelect 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.


Commands


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.
NotifySelect 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 existSelect 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 existSelect 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.
NotifySelect a notification option for this command. Options: On failure only or Do not notify.

* Setting can be specified using a parameter.


See also

transformations/powerbicommand.txt · Last modified: 2021/09/23 05:22 by dmitry