{{ transformations:PowerBICommandAction.png}}
====== POWER BI COMMAND ======
Category: Workflow / App/Cloud\\

\\ 
=====Description=====
This action triggers an action in the Power BI Service remotely. A configured [[connectors:powerbi|Power BI connector]] is required.

\\ 
=====Action settings=====
^ Setting  ^ Description  ^
|Connector<sup>*</sup>|Select the preconfigured Power BI connector, or, build one by selecting //Add connector//.\\  See [[connectors:powerbi|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.|
<sup>*</sup> Setting can be specified using a [[:parameters|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<sup>*</sup>|Enter or select the workspace to retrieve the list of datasets from.|
<sup>*</sup> Setting can be specified using a [[:parameters|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 [[transformations:exportpowerbi|"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<sup>*</sup>|Enter or select the workspace to retrieve the list of datasets from.|
|Dataset<sup>*</sup>|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//.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].

\\ 
====Delete all table rows====
**Description:** Delete all table rows in specified dataset.
^ Setting  ^ Description  ^
|Workspace<sup>*</sup>|Enter or select the workspace to retrieve the list of datasets from.|
|Dataset<sup>*</sup>|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<sup>*</sup>|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).|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].

\\ 
====List dataflows====
**Description:** Returns a list of all dataflows from the specified workspace.
^ Setting  ^ Description  ^
|Workspace<sup>*</sup>|Enter or select the workspace to retrieve the list of dataflows from.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].

\\ 
====Refresh dataflow====
**Description:** Triggers the specified dataflow.
^ Setting  ^ Description  ^
|Workspace<sup>*</sup>|Enter or select the workspace the dataflow resides in.|
|Dataset<sup>*</sup>|Enter or select the dataflow to refresh.|
|Notify|Select a notification option for this command.  Options:  //On failure only// or //Do not notify//.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].

\\ 
=====See also=====
  * [[transformations:exportpowerbi|Export to Power BI]]