Incremental Refresh - Archive load times out

Hi satkin2,

Thank you for reaching out in Microsoft Community Forum.

Thank you lbendlin  for the helpful response.

Please follow below steps to acheive this;

1.Break the 60-month archive into smaller chunks (e.g., by year) and load them separately to avoid timeouts.

2.Create a pre-filtered staging table in SQL Server for the 60-month data to reduce load time and complexity.

3.If using Power BI Premium, consider hybrid tables — import archive data and use DirectQuery for recent months.

4.Once the archive is loaded, turn on incremental refresh to manage future loads efficiently.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.