Power BI is an application that allows you to visualize and present data to your stakeholders. It can take data from a variety of sources.
Workfront Fusion is not a data source. While Workfront Fusion can create and use data sources, it does not store your data.
You must have the following access to use the functionality in this article:
Adobe Workfront plan* | Pro or higher |
Adobe Workfront license* | Plan, Work |
Adobe Workfront Fusion license** |
Current license requirement: No Workfront Fusion license requirement. Or Legacy license requirement: Workfront Fusion for Work Automation and Integration |
Product |
Current product requirement: If you have the Select or Prime Adobe Workfront Plan, your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan. Or Legacy product requirement: Your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article. |
*To find out what plan, license type, or access you have, contact your Workfront administrator.
**For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses
When you configure Power BI, Workfront Fusion displays the fields listed below. Along with these, additional fields might display, depending on factors such as your access level in the app or service. A bold title in a module indicates a required field.
If you see the map button above a field or function, you can use it to set variables and functions for that field. For more information, see Map information from one module to another in Adobe Workfront Fusion.
This search module retrieves a list of dashboards.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Group ID |
Select or map the ID of the Group that owns the dashboards you want to list. |
Limit |
Enter or map the maximum number of records you want the module to return during each scenario execution cycle. |
This search module retrieves a list of dashboard tiles.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a Dashboard ID |
Select or map the option to choose the dashboard whose tiles you want to list. |
Dashboard ID |
Enter or map the ID of the dashboard that contains the tiles you want to list. |
Group ID | Select or map the ID of the Group that owns the dashboards that contains the tiles you want to list. |
Limit |
Enter or map the maximum number of records you want the module to return during each scenario execution cycle. |
This action module retrieves metadata of a specified dashboard.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a Dashboard ID |
Select or map the option to choose the dashboard that you want to retrieve metadata for. |
Dashboard ID |
Enter or map the ID of the dashboard that you want to retrieve metadata for. |
Group ID | Select or map the ID of the Group that owns the dashboardsthat you want to retrieve metadata for. |
This action module retrieves metadata of a specified dashboard tile.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a Dashboard ID |
Select or map the option to choose the dashboard details you want to retrieve. |
Dashboard ID |
Enter or map the ID of the dashboard that you want to retrieve details for. |
Tile ID | Enter or map the ID of the Power BI tile you want to retrieve details for. |
Group ID | Select or map the ID of the Group that owns the tile you want to retrieve. |
This action module creates a new dashboard.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Name | Enter or map a name for the Dashboard. |
Group ID | Select or map the ID of the Group that will own the new Dashboard. |
This search module retrieves a list of reports.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Group ID |
Select or map the ID of the Group that owns the reports you want to list. |
Limit |
Enter or map the maximum number of records you want the module to return during each scenario execution cycle. |
This action module retrieves metadata of a specified report.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a Report ID |
Select or map the option to choose the report that you want to retrieve metadata for. |
Report ID |
Enter or map the ID of the report that you want to retrieve metadata for. |
Group ID | Select or map the ID of the Group that owns the report that you want to retrieve metadata for. |
This action module copies an existing report.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a Report ID |
Select or map the option to choose the report that you want to copy. |
Report ID |
Enter or map the ID of the report that you want to copy. |
Group ID | Select or map the ID of the Group that owns the report that you want to copy. |
New Copied Report Name | Enter or map a name for the new report. |
This action module deletes a report.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a Report ID |
Select or map the option to choose the report that you want to delete. |
Report ID |
Enter or map the ID of the report that you want to delete. |
Group ID | Select or map the ID of the Group that owns the report that you want to delete. |
This search module retrieves a list of datasets.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Group ID | Select or map the ID of the Group that owns the report that you want to retrieve metadata for. |
Limit |
Enter or map the maximum number of records you want the module to [action] during each scenario execution cycle. |
This action module retrieves metadata of a specified dataset.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a Report ID |
Select or map the option to choose the report that you want to retrieve metadata for. |
Report ID |
Enter or map the ID of the dataset that you want to retrieve metadata for. |
Group ID | Select or map the ID of the Group that owns the dataset that you want to retrieve metadata for. |
This action module creates a new dataset.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Name | Enter or map a name for the dataset. |
Group ID | Select or map the ID of the Group that will own the new dataset. |
Default Mode |
Select or map the default mode for the dataset:
|
Tables | Add tables to the dataset. For fields, see Table fields |
Data sources | Add the data sources. For fields, see Data sources fields. |
Default Retention Policy |
Select or map the intentional policy for the dataset:
|
Name |
Enter or map a name for the table. |
Columns |
Add the columns:
|
Rows | Enter or map row details. |
Measures | Add the measure for the tables. |
Database |
Enter or map the database that you want to use. |
Server |
Enter or map the name of the server you want to use. |
URL |
Enter or map the URL that you want to use. |
Data source ID |
Enter or map the ID of the data source. |
Data source Type |
Select or map the data source type. Example: SQL. |
Gateway ID | Enter or map the ID of the gateway you want to use. |
This action module adds or deletes rows of a specified push dataset table.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a table | Select or map the option to select the dataset that contains the table you want to adjust.. |
Dataset ID | Enter or map the ID of the dataset that contains the rows you want to add or delete. |
Table Name |
Enter or map the name of the table that contains the rows you want to add or delete. |
Group ID | Enter or map the ID of the group that owns the dataset. |
Select the Action |
Select or map the action that you want to perform.
|
Rows |
Add the row fields.
|
This action module refreshes a specified dataset.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a dataset | Select or map the option to select the dataset that you want to refresh. |
Dataset ID | Enter or map the ID of the dataset that you want to refresh. |
Table Name |
Enter or map the name of the table that contains the rows you want to add or delete. |
Group ID | Enter or map the ID of the group that owns the dataset. |
Notify Option |
Select or map the option to notify:
|
This action module deletes a dataset.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Enter a Report ID |
Select or map the option to choose the dataset that you want to delete. |
Report ID |
Enter or map the ID of the dataset that you want to delete. |
Group ID | Select or map the ID of the Group that owns the dataset that you want to delete. |
This trigger module starts a scenario when an app is updated.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Limit |
Enter or map the maximum number of records you want the module to return during each scenario execution cycle. |
This search module retrieves a list of all apps installed.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Limit |
Enter or map the maximum number of records you want the module to return during each scenario execution cycle. |
This search module retrieves a list of all reports from the specified app.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
App ID | Select or map the ID of the app that you want to list reports from. |
Limit |
Enter or map the maximum number of records you want the module to return during each scenario execution cycle. |
This search module retrieves a list of dashboards from a specified app.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
App ID | Select or map the ID of the app that you want to list dashboards from. |
Limit |
Enter or map the maximum number of records you want the module to return during each scenario execution cycle. |
This action module retrieves metadata of a specified app.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
App ID |
Select or map the ID of the app you want to retrieve. |
This action module retrieves metadata of a specified app’s report.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
App ID |
Select or map the ID of the app that contains the report you want to retrieve. |
Report ID |
Select or map the ID of the report you want to retreive. |
This action module retrieves metadata of a specified app’s dashboard.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
App ID |
Select or map the ID of the app that contains the dashboard you want to retrieve. |
Report ID |
Select or map the ID of the dashboard you want to retreive. |
This action module performs an API call to the Power BI API.
Connection | For instructions about connecting your Power BI account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Path |
Enter a path relative to |
Method |
Select the HTTP request method you need to configure the API call. For more information, see HTTP request methods. |
Headers |
Add the headers of the request in the form of a standard JSON object. For example, Workfront Fusion adds authorization headers and x-api-key headers automatically. |
Query String |
Enter the request query string. |
Body | Add the body content for the API call in the form of a standard JSON object. Note: When using conditional statements such as |