Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@mahoneypat Is it possible at all to fire an automated cloud flow in PA upon successful dataset refresh?
I don't see any trigger at all. It is possible to fire a query, just don't see the trigger at all.
Am I missing something, doing something wrong? Is there a way out?
I need to know how to trigger a query upon dataset refresh, required for archiving and subsequent comp.
Thank you in advance.
Solved! Go to Solution.
There isn't an OOB trigger for that, but here are 3 approaches to consider:
1. Trigger your refresh with Power Automate (based on a schedule or some other trigger), wait the time needed to refresh, and then do your other actions.
2. Create a simple dashboard from your dataset with a simple Alert that is always true (e.g., # rows >0), and then use that Alert to trigger your flow.
3. Use the refresh history Power BI REST API and run it at the needed frequency, parse the response to detect if the refresh is complete for that dataset with a condition, and then add your actions on the true.
#2 is probably the simplest/best approach
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
There isn't an OOB trigger for that, but here are 3 approaches to consider:
1. Trigger your refresh with Power Automate (based on a schedule or some other trigger), wait the time needed to refresh, and then do your other actions.
2. Create a simple dashboard from your dataset with a simple Alert that is always true (e.g., # rows >0), and then use that Alert to trigger your flow.
3. Use the refresh history Power BI REST API and run it at the needed frequency, parse the response to detect if the refresh is complete for that dataset with a condition, and then add your actions on the true.
#2 is probably the simplest/best approach
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I would call #2 a hack (but a nice one). Personally I use #3.
Needs more details. Are you initiating an enhanced refresh request or a standard request?
For a standard request you need to do similar polling but instead of using a requestid you need to poll the history (ideally with $top=1) .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |