{{ 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. \\ =====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 [[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.| * Setting can be specified using a [[:parameters|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 [[:parameters|parameter]] or the first value of a column. \\ ====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*|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 [[:parameters|parameter]] or the first value of a column. \\ ====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 [[:parameters|parameter]] or the first value of a column. \\ ====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 [[:parameters|parameter]] or the first value of a column. \\ ====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 [[:parameters|parameter]] or the first value of a column. \\ ====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 [[:parameters|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 filtering by multiple values using a single "Value" box.| * Setting can be specified using a [[:parameters|parameter]] or the first value of a column. \\ =====See also===== * [[transformations:exportpowerbi|Export to Power BI]]