Actions24
- Admin Actions
- Dashboard Actions
- Dataset Actions
- Group Actions
- Report Actions
- Token Actions
Overview
The "Add Rows" operation for the Dataset resource in this Power BI node allows users to append new rows of data to a specified table within a Power BI dataset. This is useful when you want to programmatically update your Power BI datasets with fresh or incremental data without manually uploading files or using other interfaces.
Common scenarios include:
- Automating data ingestion pipelines where new records are continuously added to Power BI tables.
- Integrating external systems or databases that push updates directly into Power BI datasets.
- Enabling real-time or near-real-time dashboard updates by adding rows as new data arrives.
For example, you might use this node to add sales transaction records from an e-commerce platform directly into a Power BI dataset table, ensuring dashboards reflect the latest sales figures.
Properties
| Name | Meaning |
|---|---|
| Authentication Token | Bearer token for authentication (without the "Bearer" prefix). Required to authorize API calls. |
| Group (Workspace) | Power BI group (workspace) ID. Leave blank to use "My Workspace". |
| Dataset | ID of the dataset to which rows will be added. |
| Table Name | Name of the table within the dataset where rows will be appended. |
| Data | The data to be added to the table, provided in JSON format. |
Output
The node outputs JSON data representing the response from the Power BI API after attempting to add rows to the specified table. This typically includes status information about the operation, such as success confirmation or error details if the addition failed.
If the operation supports binary data output (not indicated here), it would represent any file or media content returned by the API, but for adding rows, the output is purely JSON.
Dependencies
- Requires a valid Bearer authentication token for the Power BI API.
- The token must have sufficient permissions to access the specified workspace, dataset, and table.
- No additional external dependencies beyond the Power BI REST API.
- The node expects the user to provide or supply via input the authentication token.
- Proper configuration of the Power BI environment and API access rights is necessary.
Troubleshooting
- Missing or invalid authentication token: The node throws an error if no token is provided or if the token is invalid. Ensure the token is current and has the required scopes.
- Invalid group/workspace ID: If the group ID is incorrect or inaccessible, the API call will fail. Verify the workspace exists and the token has access.
- Dataset or table not found: Errors occur if the dataset ID or table name does not exist or is misspelled. Confirm these values before running.
- Malformed JSON data: The "Data" property must be valid JSON matching the schema of the target table. Invalid JSON or mismatched fields cause API errors.
- API rate limits or service issues: Temporary failures may happen due to Power BI service limits or outages. Retry after some time or check service status.