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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.