Forum Discussion

Aggie68's avatar
Aggie68
New Member
27 days ago

DataFlow Gen 1 Refresh Multiple Folders

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 ...
Dataflow
Need Help
Shai_Karmani's avatar
Shai_Karmani
Super User
26 days ago

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