Forum Discussion
Regading the database used by PBI report server
taowang wrote:
Can we use any other relational database(for example Redshift) instead of SQL Server?
In this case, will the PBI still supported by Microsoft?
No you cannot. You must use a SQL Server instance.
But you as long as you run the SQL instance on the same cores that you have licensed for Report Server you should be fine. My understanding is the same as is noted in this blog post https://joeydantoni.com/2020/05/19/licensing-sql-server-power-bi-reporting-services-integration-services-and-analysis-services/ I'm sure the official docs had a note to this effect somewhere but I've just searched and cannot find it. You try could contacting your local Microsoft office, they should be able to confirm this.
Super User
taowang wrote:
Can we use any other relational database(for example Redshift) instead of SQL Server?
In this case, will the PBI still supported by Microsoft?
No you cannot. You must use a SQL Server instance.
But you as long as you run the SQL instance on the same cores that you have licensed for Report Server you should be fine. My understanding is the same as is noted in this blog post https://joeydantoni.com/2020/05/19/licensing-sql-server-power-bi-reporting-services-integration-services-and-analysis-services/ I'm sure the official docs had a note to this effect somewhere but I've just searched and cannot find it. You try could contacting your local Microsoft office, they should be able to confirm this.