I am trying to run a paginated report (Fabric capacity). The paginated report runs on stored procedure to fetch data from Azure SQL db via VNET data gateway connection. We got this error few times already:
Cannot read the next data row for the dataset 'ABC1'. Reading a batch of rows from a data reader exceeded the timeout of 60 seconds.
We have checked out log, the stored procedure process is successful and we have asked our network team, and it seems to them this is unrelated with their scope. May I know if anyone is familiar with this issue?