Power BI Header Auth icon

Power BI Header Auth

Work with the Power BI API using header authentication

Dataset → Add Rows

AI-generated

Summary

Add rows of JSON-formatted data to a specified table within a Power BI dataset, optionally in a specific group (workspace).

Inputs

  • Authentication Token (required) — Bearer token for authentication (without the "Bearer" prefix). This token is mandatory for API access.
  • Group (Workspace) Name or ID — ID of the Power BI group (workspace) containing the target dataset. Leave blank to use "My Workspace".
  • Dataset Name or ID (required) — ID of the dataset containing the table to which rows will be added.
  • Table Name or ID (required) — Name or ID of the table inside the dataset where the data rows will be inserted.
  • Data (required) — The data to be added to the table, provided in JSON format representing the rows to insert.

Output shape

a list containing the API response for each added row operation, typically confirming success or detailing errors

If the Power BI API responds with errors or issues, those will be included in the output. The operation requires a valid authentication token and correct IDs/names for group, dataset, and table. No automatic pagination applies, as this operation adds data rows rather than listing items.

Discussion