Wiresk

Wiresk

Power BI – Triggers

Estimated reading time: 2 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 configuring your Trigger, you can load sample data into the Example Input panel in Flow Builder. This gives you a preview of what the Trigger returns and prepares the data for mapping.

How to get it:

  • Enter manually: Add your own sample data in the JSON editor, plain JSON string, or form view.
  • Use predefined Trigger samples: Triggers provide ready-made sample data that can be pulled directly into the Example Input panel.
  • Capture Example Input: Enable this option to record real data the next time the Flow runs. The captured sample will automatically appear in the panel.

With Sample Input in place, you can review the field structure and connect Trigger outputs to Method parameters with confidence.

For more details, refer to Example Input – How it Works.

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

⚠️ 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

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

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.

Important 01 Power BI - Triggers

Going further Copy Link

See related Microsoft apps.

Explore the full Wiresk User Guide to learn more.

Looking for an integration that’s not yet available? Submit a request to our team, we’ll do our best to support your needs.