Auto update table with historical data

[Redfox_delta1]

Hi Power BI users,

I have a power BI file with a table.

1- Table 1 contains historical data made from the combination of 3 separate CVS

2. Table 2 data comes from an API connection pull refreshed every 3 days.

How do I get the historical data in table 1 to automatically update with fresh data from table 2 every 3 days. So that when I open table 1 i can see the table with the latest data to date.

[v-stephen-msft · Accepted solution]

Hi @Redfox_delta1 ,

If the report is published to Power BI Service, you can configure the scheduled refresh:

Configure scheduled refresh - Power BI | Microsoft Learn

Or incremental refresh:

Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn

If you want to refresh in Power BI Desktop, click "Refresh" button:

Refresh datasets created from local Power BI Desktop files - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.