DataFlow Gen 1 Refresh Multiple Folders

[Aggie68]

Hello!  In power bi dataflow Gen 1, I'm getting data from site 1 folder on the SPO site. It has a timer refresh. Onces that refresh is completed I would like it to refresh again but this time I need the data to come from site 2 folder on the SPO site.  How do I code it so that it automactially point to site 2 folder on the SPO site the refresh the second time?  Thanks

[v-sathmakuri]

Hi  @Aggie68 ,

Could you please review the suggestion provided above and let us know if you still have any further questions?

Thanks!!

[Shai_Karmani]

Dataflows Gen 1 don't support alternating the source per refresh. The query is static and always runs against whatever folder it points to.

The two common patterns are: read both folders in the same query (SharePoint.Contents at the site root, expand, then filter to keep files from both folder paths, so the dataflow loads everything on each refresh); or split into two dataflows, one per folder, and schedule them at different times, then combine them downstream in the model or in another dataflow.

If you really need alternate source per refresh you would have to change the source parameter between refreshes via the Fabric REST API, but that is operational overhead most teams avoid.

If this helped, a thumbs up and accepting the solution would be appreciated.

Best,
Shai Karmani

Let's connect in LinkedIn