PowerBI Refresh Error
PowerBI App + Azure SQL Database(Serverless, Gen5, 2Vcores) with autopause after 1 hour. PowerBI fetches the data from Azure SQL Database using a SQL view with under 15M records everyday. This refresh takes about 10 minutes to refresh in PowerBI desktop. When I refresh it manually on PowerBi web, It takes under 5 min. But When I am trying to schedule the dataset refresh, it throws an error. ------------------------------------- Last refresh failed: Tue Jan 12 2021 13:44:23 GMT+0530 (India Standard Time) There was an error when processing the data in the dataset.Hide details Processing error: Microsoft SQL: Server provided routing information, but timeout already expired. Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net Activity ID: 55091bfd-ce22-4ac6-b38b-7c199de0d392 Request ID: a3480078-1a6f-4afd-adc1-3f71cb734436 Time: 2021-01-12 08:14:23Z ---------------------------------------------------------------------- Can this be because of the serverless setup of the Azure Sql db with an autopause feature after 1 hour. Kindly help!!!