How to run a query against a dataset in power automate?
Published Date - 

How to run a query against a dataset in power automate?



  • Access to Power Automate
  • Published Dataset
  • Power BI Desktop

Power BI and Power Automate have emerged as powerful tools to harness the potential of data. In this blog post, we'll explore a practical scenario where you can seamlessly send notifications based on Power BI data using Power Automate. Specifically, we'll walk through the process of sending notifications to users who haven't logged their work hours, demonstrating the efficiency and ease of integrating these Microsoft Power Platform tools.

Example: Work Hours Tracking Notification

This example demonstrates how to send an email notification to users who haven't logged their worked hours:

Steps 1: Power BI Desktop

To start the process, open the report in Power BI Desktop and follow these steps:

  • Create a new tab: Add a "Power Automate" tab or any descriptive name.
  • Add Visual: Add a table Visual from the visualization pane
  • Apply filters: Select "Visualizations"> "Filters" and create a filter where "Logged Hours" equals 0.
Running Query in Power Automate
  • Performance Analysis: Navigate to the Optimize tab and select Performance Analyzer. Start recording, then click Refresh Visual to capture and analyze the query.
Power Automate Dataset Query
Power Automate Dataset Query2
  • Copy Query: Once the performance analysis is complete, copy the generated query. This will be crucial for the subsequent steps in Power Automate.

Step 2: Power Automate Integration

Now, let's seamlessly integrate Power BI data with Power Automate to automate notifications:

  • Create a flow: Click "Create" > "Scheduled Cloud Flow".
  • Set the frequency: Choose the desired interval for checking (e.g., daily, hourly).
  • Add a trigger: Search for "Power BI" > "Run a query against a dataset."
  • Select the workspace and then choose the dataset from the dropdown menu.
Power BI Data in Power Automate
  • Input Query Text: Paste the previously copied query from Power BI Desktop into the Query Text field. This ensures that Power Automate retrieves the specific dataset based on your defined criteria.
  • Parse the retrieved data.
  • Condition Check (Optional): Set up any additional condition to check if needed.
Automating Data Queries Power Automate
  • Send Notification: Add Send an email action to send a notification.

Schedule Your Expert Session

Are you on the lookout for top-tier Power BI consultancy or specialized Power Automate consulting services to enhance your business's data management and automation strategies? Look no further! Our team of seasoned experts is here to guide you through the complexities of data visualization and process automation, ensuring your business leverages the full spectrum of capabilities offered by Power BI and Power Automate.

Don't miss this opportunity to transform your data strategy and automation processes. Connect with us. Schedule your consultation today with our experts. Our dedicated support will help you navigate the evolving digital landscape, ensuring your business remains ahead of the curve. Let's work together to turn your data into your most powerful asset and optimize your workflows for maximum efficiency.

No items found.


No items found.

Contact us

How can we help you?

Thank you!

We will get back to you in one business day.
If this is urgent, Please schedule a time
Oops! Something went wrong while submitting the form.