Reports connected to Azure SQL Server are suddently experiencing Timeout expired error

Hi,

Some of my reports connected to Azure SQL Server through Import storage mode is now experiencing Timeout Expired error. This dataset is shared between 2 reports, where one uses Live Conection to PBI Dataset of another.

The refresh on PBI Desktop works fine, but once it's on Service and perform refresh either by On-demand or Scheduled, it fails sometimes and some other time it works.

My guess is, because there are 2 reports connected to the same tables through import (One with shared dataset with scheduled refresh set at 6AM, another report with the same dataset set to refresh at 7:30AM) in SQL server and the failed report was trying to connect to it while another was updating. But the same behaviour is also observed for a completely different report with much smaller dataset, which is not shared or have overlapping refresh schedule.

I'm not sure if this makes sense but from looking at past forums, the problem seem to be an on-and-off thing. Would this be the case or is my assumption correct?

The size of the failed report is 830MB and the workspace it is published to is in Pro. The report also uses Incremental Refresh.

Any reply is appreciated. Thanks!