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?
Great question,
at this moment it doesn't seem to be working as I'm getting the following error in the last
System.Data.SqlClient.SqlException (0x80131904): Keyword or statement option 'RECOVERY' is not supported in this version of SQL Server.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
Please also see official support documentation here: https://docs.microsoft.com/en-us/power-bi/report-server/system-requirements
As per this documentation, Azure SQL Managaged Instance is supported (Power BI Report Server January 2020 version and later).