Forum Discussion
Power BI Reports Server with Azure SQL Database
Is it possible to use an Azure SQL Database for the underlying database of your Power BI Reports Server?
Update to the situation:
Now Microsoft documentation says that Azure SQL Managed Instance is supported.
But the result is still same: it doesn't work with the latest SSRS 2021-06 release.
Error is the same and this setting doesn't exist, so you can't change it with SSMS or with ALTER DATABASE command.
Manual installation might be an option, but the hardest part in that is that you need to populate the database from a backup you take from a successful installation. I have not tested if this would work or not.