[ 1 Connect Power BI with Devo SOAR ] [ 2 Actions for Power BI ] [ 2.1 Post Rows ] [ 2.1.1 Input Field ] [ 2.1.2 Output ] [ 3 Release Notes ]

It is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.

Connect Power BI with Devo SOAR

Navigate to Automations > Integrations.
Search for Power BI.
Click Details, then the + icon. Enter the required information in the following fields.
Label: Connection name.
Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.
Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).
Api Token: Api Token to access Power BI.
After you've entered all the details, click Connect.

Actions for Power BI

Post Rows

Adds new data rows to the specified table within the specified dataset from My workspace.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name	Description	Required

Input Name	Description	Required
Dataset ID	Jinja-template for the dataset ID.	Required
Table Name	Jinja-template for the table name.	Required
Data Rows	Jinja-template for an array of data rows pushed to a dataset table. For example: [{"name":"logichub"},{"name":"playground"}]	Required

Output

JSON containing following items:

{json}{ "result": "Successful" "error": null, "has_error": false }

Release Notes

v2.0.0 - Updated architecture to support IO via filesystem
v1.0.1 - Added Post Rows action.