Power BI icon

Power BI

Work with the Power BI API

Actions32

Overview

The node integrates with the Power BI API to add rows of data into a specified table within a dataset. This operation is useful for automating data ingestion workflows where new data needs to be appended to existing Power BI datasets, enabling real-time or batch updates to reports and dashboards.

Common scenarios include:

  • Automatically appending new sales records or transaction logs to a Power BI dataset.
  • Feeding processed or transformed data from other systems directly into Power BI tables.
  • Enabling dynamic data refreshes without manual intervention by pushing data programmatically.

For example, you might use this node to add daily customer feedback entries collected from a form into a Power BI dataset table for immediate visualization.

Properties

Name Meaning
Authentication Method used to authenticate with Power BI API. Options: OAuth2 or Bearer Token.
Group (Workspace) Name or ID The Power BI workspace (group) where the dataset resides. Leave blank to use "My Workspace". You can select from a list or specify an ID via expression.
Dataset Name or ID The identifier of the dataset to which rows will be added. Required. Select from a list or specify an ID via expression.
Table Name or ID The name or ID of the table within the dataset where rows will be inserted. Required. Select from a list or specify an ID via expression.
Data The actual data to add to the table, provided in JSON format. This should match the schema of the target table. Required.

Output

The node outputs JSON data representing the result of the add rows operation. Typically, this includes confirmation of successful insertion or details about any errors encountered during the process.

If the operation supports binary data output (not indicated here), it would represent related binary content such as file attachments or export data, but this node focuses on JSON data manipulation.

Dependencies

  • Requires valid authentication credentials for Power BI API access, either via OAuth2 or a bearer token.
  • Needs proper configuration of the Power BI workspace, dataset, and table to ensure the data matches the expected schema.
  • The node depends on n8n's internal methods to load options dynamically for groups, datasets, and tables.

Troubleshooting

  • Authentication Errors: Ensure that the selected authentication method is correctly configured with valid credentials. OAuth2 tokens may expire and need refreshing.
  • Invalid Dataset or Table IDs: Verify that the group, dataset, and table identifiers are correct and accessible by the authenticated user.
  • Schema Mismatch: The JSON data must conform to the table schema; otherwise, the API will reject the rows. Validate the data structure before sending.
  • API Rate Limits: Frequent or large data insertions may hit Power BI API rate limits. Consider batching data or adding delays.
  • Error Messages: If the node returns error messages, check the message details for hints such as permission issues, invalid parameters, or network problems.

Links and References

Discussion