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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors