Wiresk

Wiresk

Power BI – Triggers

Estimated reading time: 4 min

What will start your automation…

Run Once Tab: This tab allows you to schedule a Flow to execute a single time at a specific date and time. This is ideal for one-time operations such as data syncs, cleanups, or initial configuration steps. After execution, the schedule will be automatically cleared unless rescheduled manually.

Run Tab: This tab is used to set up repeating schedules:

  • Repeat feature: This dropdown determines how long the automation will continue repeating based on the selected frequency (Minutely or Hourly). You can choose from:
    • Repeat Forever
      • The automation will continue to run indefinitely at the defined interval (e.g. every 15 minutes).
      • No end condition is specified.
    • Repeat for (x) Times
      • You set a specific number of repetitions.
      • Requires the field Number (x) of Repeat Times to be filled (e.g. 10 times).
    • Repeat Between Start & End Dates
      • The automation will run only within a defined date range.
      • Additional fields will appear to select start and end dates.
      • Useful for limited-time schedules like campaigns or batch jobs.
  • Daily at Multiple Times: Sets the Flow to run several times per day based on a minutely or hourly interval.
  • Daily: This allows a Flow to run x times per day at a specific time.
  • Weekly: This allows you to run a Flow weekly by selecting the days and time.
  • Monthly: This will monitor your Trigger every month on a defined date and hour.
  • Yearly: This will monitor your Trigger on a specific date and hour every year.
  • Specific dates: This will start your Trigger on specific dates and time.

For more details, see Wiresk Scheduler – The Fundamentals.

After you’ve configured your Trigger parameters, select the “Use” button to fetch a live sample of data from the Trigger.

What it does:

  • Extracts real data based on your Trigger setup
  • Validates your parameters by showing if they match existing records
  • Prepares data for field mapping – the sample helps you map your Trigger output to your Method parameters in the Flow. Refer to FIELD MAPPING documentation.

Think of it as a preview step: it makes sure your Trigger is working and gives you real data to work with when setting up the rest of your flow.

POWER BI Power BI - Triggers

These Triggers will start your Flow automatically at a specific time or intervals instead of being triggered by events like Webhooks.

This Trigger is used to retrieve all rows from a specific datasets table.

For more detail, see Power BI API reference Datasets GetTables

Configuration Table:

Name*Get Table Rows
Connection*Select your connection or create one.
TimeoutYou can additionally set the Trigger duration to limit the information processed per execution to optimize performance and resource usage.
Recurrence Rule/scheduler*Set up your recurrence rule.

PARAMETERS

This tab enables you to configure the Trigger.

Workspace*:

Select your workspace.

Datasets ID*:

Select the Datasets ID.

Table Name*:

Select the Table.

This tab allows you to preview the data that will be retrieved and included in the output.

In specific Trigger instances, data can only be previewed when it is available for retrieval. If no event occurs from the Trigger, a message “No data available” will be displayed.

preview data button 2025 04 09 Power BI - Triggers

Use this button to preview the data based on the “Configure Parameter” tab.

(*) required field

⚠️ Reminder: Click “Use” to validate your Trigger with sample data before saving.

⚠️ This Trigger requires at least 1 record to generate the sample data input, as it is dynamic based on form data.

Retrieve multiple rows from Power BI using Wiresk’s Query Builder.

A Query Builder allows you to create complex SQL queries without having to write any code.

Learn more about how to use Wiresk’s Query Builder here.

Configuration Table:

Name*Retrieve database record using Wiresk’s Query Builder
Connection*Select your connection or create one.
TimeoutYou can additionally set the Trigger duration to limit the information processed per execution to optimize performance and resource usage.
Recurrence Rule/scheduler*Set up your recurrence rule.

PARAMETERS

Workspace*:

Select your workspace.

Dataset*:

Select your Power BI Dataset.

Entity*:

Select the entity (set of data) from which data will be retrieved.

This tab enables you to define specific criteria to narrow down the records being retrieved.

Screenshot 2025 03 21 at 2.13.04 in the afternoon Power BI - Triggers

Select the button to configure filters.

Configure which columns or fields of data will be retrieved and included in the output.

Wiresk 2025 06 02 at 09.12.55 Power BI - Triggers

To visualize the records. You must select at least 1 Columns to get the Preview Data.
If you get this message:” Cannot convert undefined or null to object”, it means there is no records.

Wiresk 2025 06 02 at 09.12.25 Power BI - Triggers

Customize which columns are displayed and retrieved. Minimum 1 column, maximum 50 columns.

Wiresk 2025 06 02 at 09.12.39 Power BI - Triggers

This option is for sorting the data in the columns by Ascending or descending order.

Number of records:10

By default, 10 records will be shown.

Begin at record: 0

The display starts at record 0.

(*) required field

⚠️ Reminder: Click “Use” to validate your Trigger with sample data before saving.

This Method allows you to run a custom DAX expression against a Power BI dataset and return results directly. It uses Power BI’s Execute Queries REST API to perform the operation.
 
⚠️ Important API Limitations:
• Only one DAX query per call.
• Returns a single table.
• Limits: 100,000 rows or 1,000,000 cells (rows × columns), whichever is lower.
• Payload size capped at 15MB.

For more detail, see Power BI API reference DAX Queries

Configuration Table:

Name*Get Dataset Data by DAX Query
Connection*Select your connection or create one.
TimeoutYou can additionally set the Trigger duration to limit the information processed per execution to optimize performance and resource usage.
Recurrence Rule/scheduler*Set up your recurrence rule.

PARAMETERS

This tab enables you to configure the Trigger.

Workspace*:

Select your workspace.

Datasets ID*:

Select the Datasets ID.

DAX Query*:

The body’s query property (your DAX code, e.g. EVALUATE + table expression).

This tab allows you to preview the data that will be retrieved and included in the output.

In specific Trigger instances, data can only be previewed when it is available for retrieval. If no event occurs from the Trigger, a message “No data available” will be displayed.

preview data button 2025 04 09 Power BI - Triggers

Use this button to preview the data based on the “Configure Parameter” tab.

(*) required field

⚠️ Reminder: Click “Use” to validate your Trigger with sample data before saving.

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.