Forum Discussion

Icon for Helper V rank

Helper V

5 years ago

Solved

General question on refresh cascade in linked Power BI Dataflows

Setup: I have a core Dataflow which ingests a dozen Azure SQL DB tables. ETL processing is light because we did most of the heavy lifting in T-SQL. Most of the content is dimensional or small fact t...

GilbertQ
5 years ago
Hi tommy_g

I do agree it might be a bit of overkill, but to me it would certainly work as expected.

Icon for Super User rank

Super User

5 years ago

As far as I am aware it would need to not be a linked entity to stop the refreshing of associated dataflows?

tommy_g
Helper V
5 years ago
But I do want to ensure the dependent workflow is refreshed.

Your reply implies that the parent linked workflow does, indeed, cascade down to the dependent child.

By implication, one could establish a top-level refresh schedule (parent) on a frequency as high as the any one of the dependent workflows would need, based on incoming facts throughout the day.

It might be overkill, but also the simplest and most reliable way to attain a consistent reporting base.

I think we are 90% to "accept as solution". How does my theory resonate with you?
- GilbertQ
  Super User
  5 years ago
  Hi tommy_g
  
  I do agree it might be a bit of overkill, but to me it would certainly work as expected.
  - tommy_g
    Helper V
    5 years ago
    Looks like I was not sufficiently precise on my search. "Cascade" is not close enough, the official term is "Orchestration". I remember a distant Amir Netz preview from a few years back. At least I remembered the key concept <g>
    
    Develop solutions with dataflows - Power BI | Microsoft Docs