Wiresk

Wiresk

Power BI – Methods

Estimated reading time: 5 min

What your automation will do…

A connection to your Microsoft Power BI account is needed so we can sync it with our platform.
Refer to Microsoft Power BI – connection.
You can include between 1 and 255 Methods to build complex Flows.
POWER BI Power BI - Methods

Workspaces are places to collaborate with colleagues to create collections of dashboards, reports, semantic models, and paginated reports.

 Retrieves metadata for the specified workspaces.
 
Limitations:
• Maximum 500 requests per hour.
• Maximum 16 simultaneous requests.
 
For more detail, see Power BI API reference.

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.

(*) required field

Name*Find workspace
Connection*Select your connection or create one.

Matching Criteria

Workspace Name*:

Select the workspace to retrieve information from, or Map it ID.

Response sample 
{
  "id": "5f2f2ff7-7d6f-456a-a574-sj2k",
  "isReadOnly": false,
  "isOnDedicatedCapacity": false,
  "type": "Workspace",
  "name": "Wiresk"
}
Expand
POWER BI Power BI - Methods
Returns a list of principals that have access to the specified dataset.
When user permissions to a dataset have been recently updated, the new permissions might not be immediately available through API calls.
 
For more detail, see Power BI API reference.

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.

(*) required field

Name*List Dataset Users
Connection*Select your connection or create one.

Matching Criteria

Workspace Name*:

Select the workspace, or Map it ID.

Dataset ID*:

Select the dataset to retrieve the user information from, or Map it ID.

Response sample 
[
  {
    "datasetUserAccessRight": "ReadWriteReshareExplore",
    "identifier": "user@wiresk.com",
    "principalType": "User"
  }
]
Expand


POWER BI Power BI - Methods
Retrieves a dataset information from selected workspace.
 
For more detail, see Power BI API reference.

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.

(*) required field

Name*Get Dataset
Connection*Select your connection or create one.

Matching Criteria

Workspace ID*:

Select the workspace or Map it ID.

Dataset Name*:

Select the dataset to retrieve the information from, or Map it ID.

If Not Found Consider As*:

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the workflow.

Failed – Wiresk treats this as an error or failure. The workflow stops or takes a predefined failure action.

Response sample 
{
  "id": "f8ddacab-1814-471a-bc5e-7462db196cd3",
  "name": "Table",
  "webUrl": "https://app.powerbi.com/groups/b6de3e5f-67e2-4d3c-9fca-b4747e43dbef5f/datasets/f8ddacab-1814-471a-bc5e-7462db1965a6",
  "addRowsAPIEnabled": false,
  "configuredBy": "user@wiresk.com",
  "isRefreshable": true,
  "isEffectiveIdentityRequired": false,
  "isEffectiveIdentityRolesRequired": false,
  "isOnPremGatewayRequired": false,
  "targetStorageMode": "Abf",
  "createdDate": "2025-05-22T07:44:17.55Z",
  "createReportEmbedURL": "https://app.powerbi.com/reportEmbed?config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVNPVVRILUVBU1QtQVNJQS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCIsImVtYmVkRmVhdHVyZXMiOnsidXNhZ2VNZXRyaWNzVk5leHQiOnRydWV9fQ%3d%3d",
  "qnaEmbedURL": "https://app.powerbi.com/qnaEmbed?config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVNPVVRILUVBU1QtQVNJQS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCIsImVtYmVkRmVhdHVyZXMiOnsidXNhZ2VNZXRyaWNzVk5leHQiOnRydWV9fQ%3d%3d",
  "upstreamDatasets": [],
  "users": [],
  "queryScaleOutSettings": {
    "autoSyncReadOnlyReplicas": true,
    "maxReadOnlyReplicas": 0
  }
}
Expand
Get a list of dataset from a selected workspace.
 
For more detail, see Power BI API reference.

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.

(*) required field

Name*List Datasets
Connection*Select your connection or create one.

Matching Criteria

Workspace ID*:

Select the workspace or Map it ID.

Response sample 
{
  "id": "f8ddacab-1814-471a-bc5e-7462db196cd3",
  "name": "Table",
  "webUrl": "https://app.powerbi.com/groups/b6de3e5f-67e2-4d3c-9fca-b4747e43dbef5f/datasets/f8ddacab-1814-471a-bc5e-7462db1965a6",
  "addRowsAPIEnabled": false,
  "configuredBy": "user@wiresk.com",
  "isRefreshable": true,
  "isEffectiveIdentityRequired": false,
  "isEffectiveIdentityRolesRequired": false,
  "isOnPremGatewayRequired": false,
  "targetStorageMode": "Abf",
  "createdDate": "2025-05-22T07:44:17.55Z",
  "createReportEmbedURL": "https://app.powerbi.com/reportEmbed?config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVNPVVRILUVBU1QtQVNJQS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCIsImVtYmVkRmVhdHVyZXMiOnsidXNhZ2VNZXRyaWNzVk5leHQiOnRydWV9fQ%3d%3d",
  "qnaEmbedURL": "https://app.powerbi.com/qnaEmbed?config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVNPVVRILUVBU1QtQVNJQS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCIsImVtYmVkRmVhdHVyZXMiOnsidXNhZ2VNZXRyaWNzVk5leHQiOnRydWV9fQ%3d%3d",
  "upstreamDatasets": [],
  "users": [],
  "queryScaleOutSettings": {
    "autoSyncReadOnlyReplicas": true,
    "maxReadOnlyReplicas": 0
  }
}
Expand
Creates a new dataset on a specified workspace.
 
For more detail, see Power BI API reference.

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.

(*) required field

Name*Create Dataset
Connection*Select your connection or create one.

Matching Criteria

Workspace ID*:

Select the workspace or Map it ID.

Dataset Name*:

Provide the dataset name.

Tables*:

Define the tables’ structure.

+Element +Map ↓
(Add a repeating group of fields or Map it from an array. See Field Mapping).

Element 1: Represents the first table.

Name*:

name the table.

Description*:

Describe the table.

Is Hidden:

Optional. Whether this dataset table is hidden.

Columns:

The column schema for this table.

+Element +Map ↓
(Add a repeating group of fields or Map it from an array. See Field Mapping).

Element 1: Represents the first column.

Name*:

The column’s name.

Data Type*:

The column data type.

+ Add Field ↓
Additional fields to configure the column.

Format String:

Optional. The format of the column as specified in FORMAT_STRING.

Is Hidden:

Optional. Whether the column is hidden. The default is false.

Data Category:

Data category which describes the data within this column.

Sort by Column:

 Name of a column in the same table to be used to order the current column.

Summarize by:

The aggregate function to use for summarizing this column.

+ Add Field ↓
Additional fields to configure the table.

Measures:

The measures within this table.

Response sample 
{
  "id": "cfafbeb1-8037-4d0c-896e-a46fb27ff229",
  "name": "SalesMarketing",
  "defaultRetentionPolicy": "basicFIFO"
}
Expand
Adds new data rows to the specified table within the specified dataset from a selected workspace.
 
For more detail, see Power BI API reference.

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.

(*) required field

Name*Push Rows
Connection*Select your connection or create one.

Matching Criteria

Workspace ID*:

Select the workspace or Map it ID.

Dataset ID*:

Select the dataset or Map it ID.

Tables*:

Select the table from the selected dataset.

Map Fields

Row Data*:

Rows to add into the table.

The available rows to push depend on your table structure.

+Element +Map ↓
(Add a repeating group of fields or Map it from an array. See Field Mapping).

Element 1: Represents the first row.

“Columns name”*:

Enter value

Response sample 
{
  "@odata.context": "https://api.powerbi.com/v1.0/myorg/groups/b6de3e5f-67e2-4d3c-9fca-b47473dbef5f/$metadata#datasets/$entity",
  "id": "58efe995-378a-41a9-aec4-2a42b437db86",
  "name": "test",
  "defaultRetentionPolicy": "None",
  "upstreamDatasets": [],
  "users": []
}
Expand
Triggers a refresh for the specified dataset from a selected workspace.
 
For more detail, see Power BI API reference.

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.

(*) required field

Name*List Datasets
Connection*Select your connection or create one.

Matching Criteria

Workspace ID*:

Select the workspace or Map it ID.

Dataset ID*:

Select the dataset to refresh, or Map it ID.

Response sample 
{
  "message": "Dataset refresh successfully"
}
Expand
⚠️ Deletes all rows from the specified table within the specified dataset from a selected workspace.
 
For more detail, see Power BI API reference.

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.

(*) required field

Name*Delete Dataset Rows
Connection*Select your connection or create one.

Matching Criteria

Workspace ID*:

Select the workspace or Map it ID.

Dataset ID*:

Select the dataset to refresh, or Map it ID.

Table Name*:

Select or Map the table ID, to delete all it rows.

Response sample 
{
  "message": "Row deleted successfully"
}
Expand

Once your Flow is configured, you can test or automate it using the Run panel or by managing Triggers from the Flow Management screen.

  • Run Flow: Manually runs the Flow once using sample data. Ideal for testing logic and field mapping. See How to Run a Flow.
  • Run Scheduler: Force-runs the Trigger immediately using live input. This bypasses the recurrence rule and is useful for verifying real data mapping. Learn more in Wiresk Scheduler – The Fundamentals.

From the Trigger management panel (clock icon), you can:

  • Activate or deactivate Triggers
  • Force-run the scheduler
  • Copy Routing Keys (for HTTP Triggers)

If your Flow uses a Webhook Trigger, it runs automatically on each incoming webhook—no scheduler required. It remains active until you manually deactivate it.