Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
texmexdragon2
Helper V
Helper V

Dataflow refresh with linked tables

I have a premium p1 SKU.    Dataflows are in a premium workspace.    Dataflows feed into several datasets.      

 

Question:    Previously, I was updating each dataflow in a schedule like this:  

2023 dataflow  8am   and every hour therafter

2024 dataflow  8am   same 

Then the "All" dataflow  I was updating at 8:30  (and every half hour thereafter).      

 

Then the datasets that these feed into were being updated on the half hour as well  (along with the All dataflow).  

 

I had read somewhere that based on having "linked dataflows", which you can see below, I would not need to update the yearly dataflows, and could just update the "All" dataflow.   So I turned off their refresh.     But I've now tested this for a few days and the yearly dataflows are definitely not updating the "All" dataflow.   

 

Recommendations on how I should set this up?     The only dataflow I bring into the datasets is the "All" dataflow.   The question really is about how to set up the refresh schedules (of the yearly dataflows, the "all" dataflow, and the dataset itself).    And why are the "linked" dataflows not updating my "All" dataflow.    

 

Any help is appreciated! 

 

 

texmexdragon2_0-1707241048522.png

 

5 REPLIES 5
texmexdragon2
Helper V
Helper V

@lbendlin   Yes, I would love to go that route, but our IT dept has disabled that ability due to data sharing policies.   So I'm back to my original question as to what is the best way to handle the refresh of the (for example) 2023 and 2023 dataflows, and the "all" dataflow (which contains both of these dataflows), then the dataset itself.   Thoughts?

You can recreate the Power Automate features with calls to the Power BI REST API.  Or did your IT department block that too?

@lbendlin  I have never tried it, but looking at the documentation it seems to say that this requires a service prinicipal account, which I do not have.    

I am using it with my regular AAD account.  Don't let the name of the login cmdlet throw you off. 

lbendlin
Super User
Super User

Consider using Power Automate instead.  It has triggers for "when a dataflow refresh completes".  You can then initiate another dataflow refresh, or a semantic model refresh. Sadly there is no "when a dataset refresh completes"  trigger but you can emulate that through polling of the refresh status.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors