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.
Hello,
I'm currently using Power Automate to kick off dataset refreshes automatically based on keywords used in a group chat. With that said, I'm curious about a few things:
The end goal is this: Refresh all data sets in a programmatic way instead of having to go to the PBI Server and refresh when a report breaks. In this day of technology, I'm sure someone out there is doing this the right, efficient way.
No on #1. Scheduled Refresh in the service has very limited settings. You want to use Power Automate for this, as you are.
On #2, you'd need to ask in the Power Automate community. Get Help with Power Automate - Power Platform Community (microsoft.com) There might be a way to read all datasets in via the REST API from workspaces, and then in Power Automate do a loop on each of those.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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.