
Announcements
I am currently trying to set up automated flows with trigger - When a dataflow refresh completes, which is as following.
I have about 70 dataflow and I was wondering if it is possible to run the same flow `forEach` df in the workspace without requiring me to manually specify the dataflow name.
I can create a list with with all the dataflow names in the workspace and I was wondering if there is a way to pass each of the names on the list to this flow?
I am a new user of PA.
Thank you in advance
I don't think you can pass trigger values to a Child flow, which is what would be needed here. Unfortunately, you can't get an email on successful refresh (just failures), or you could trigger your flow from those emails (and pass in the Dataflow Id from them).
Alternatively, you could make periodic calls to the Power BI REST API to see all the dataflows and when they last refreshed, filter it to those in the last hour (for example) and then do flow actions for each of those.
Admin - Get Refreshables For Capacity - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Pat