Forum Discussion
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 ref...
Hi Anonymous
Yes this is quite certainly the case.
If the SQL Server is paused when the initial connection is tried it will fail.
Have you tried rather using the DTU version of Azure SQL Server?
It is a lot cheaper and can be run 24/7
Another option is to have some other process which will wake up or try and connect to the SQL Serverless before Power BI refreshes.
Thanks Gilbert, Will look into it!