Forum Discussion
Dataflow :: How does Power BI know what to push to server?
ichavarria Thank you. One follow-up question then:
"When the scheduled refresh occurs, Power BI dataflows fetches all the data from the source, applies the transformations, and stores the output in the destination."
Would I think of this as a truncate and a full reload? So if there are 100,000,000 records, each scheduled refresh would truncate and reload alllllll of those records?
Hi pbi_throw_away,
Do not take my word for Microsoft documentation haha, but this is my understanding yes. I have seen this behavior for multiple data sources and it happens during the "evaluation" part. If you go to the data base, you should see the query trigerring.
I would suggest you implement Using incremental refresh with dataflows - Power Query | Microsoft Learn. That way you can avoid it from happening.
Best regards,
Isaac Chavarria
If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly