Actions20
- Dataset Actions
- Group Actions
- Report Actions
- Admin Actions
- Dashboard 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 datasets with fresh or incremental data without replacing the entire dataset.
Common scenarios include:
- Automating data ingestion pipelines where new records are continuously added.
- Integrating external data sources that push updates into Power BI datasets.
- Enriching existing datasets with additional transactional or log data.
For example, you might use this operation to add daily sales records from an e-commerce platform directly into a Power BI dataset table for real-time reporting.
Properties
| Name | Meaning |
|---|---|
| Group (Workspace) | Power BI group (workspace) ID. Leave blank to use "My Workspace". This selects the workspace containing the dataset. |
| Dataset | ID of the dataset to which rows will be added. |
| Table Name | Name of the table inside the dataset where the new rows will be appended. |
| Data | The actual data to add, provided in JSON format. This should match the schema of the target table. |
Output
The node outputs JSON data representing the response from the Power BI API after attempting to add rows. Typically, this includes confirmation of success or details about any errors encountered.
If the operation supports binary data output, it is not indicated here; thus, the output is purely JSON-based reflecting the API response.
Dependencies
- Requires a valid Power BI API authentication token configured in n8n credentials.
- Access to the Power BI REST API endpoint
https://api.powerbi.com/v1.0/myorg. - The user must have appropriate permissions on the specified workspace and dataset to add rows.
Troubleshooting
- Invalid Dataset or Table: If the dataset ID or table name is incorrect or does not exist in the specified workspace, the API will return an error. Verify these IDs via the node's dropdown options or Power BI portal.
- Schema Mismatch: The JSON data must conform to the table schema. Adding rows with missing or extra fields may cause failures.
- Permission Issues: Insufficient permissions on the workspace or dataset will prevent adding rows. Ensure the API token has write access.
- Empty Workspace Field: Leaving the workspace field empty targets "My Workspace." If the dataset is not there, specify the correct workspace ID.
- API Rate Limits: Large batch inserts or frequent calls may hit Power BI API rate limits, causing throttling errors.