Dataset Refresh Fails only on a Specific Day

Hi PBI team,

I have a dataset that's been in use for a long time (2+ years), and refreshes by schedule perfectly every day.

The refresh works daily without issues but suddenly the refresh process that is happening on the 2nd day of every month started failing, showing a vague Timeout error (this has been happening only on the 2nd day of the month for several months. The refresh then completes successfully on the following days without any issues).

I have checked the data and there is nothing unusual happening with the data on that specific day when the refresh fails. The amount of data remains the same every day, and the SQL jobs retrieving the data finish in the same time as any other day.

As a workaround I tried rebuilding the indexes on the tables that are being used in the dataset source, which seems to fix the issue.

However, this is not a viable long-term solution, since rebuild of the indexes results in 4-5 hours delay in the daily refresh of the dataset.

I would be grateful for any help or guidance you can provide to help me solve this problem.

Thank you in advance for your support.