Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Appending Current Data to Large Static Data Set & Incremental Refresh

Unsure if this is the right forum, or PBI Service ( my apologies for duplication) I'm designing a report that has two tables (Historical & Current) loaded from a Power BI Dataflow into a single Po...
Need Help
Tutorial Requests
Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

I think using the following approach will work:

  1. Load only the appended table, disable the load for Historical and Current tables while keeping them for transformation (appending).
  2. Move the logic for appending the tables to Power BI Dataflows to reduce dataset size in Power BI.
  3. Set up incremental refresh on the appended table, so only new data gets refreshed, optimizing the process.