Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts
My client is planning to setup PBI report server on AWS.
While reading the relatice documents, I noticed below statement from MS.
-----------------------------
https://docs.microsoft.com/en-us/power-bi/report-server/install-report-server
To complete the initial configuration of Reporting Services, you create a report server database. A SQL Server Database server is required to complete this step.
Then
SQL Server Reporting Services native mode uses two SQL Server relational databases to store report server metadata and objects. One database is used for primary storage, and the second one stores temporary data
-----------------------------
Can we use any other relational database(for example Redshift) instead of SQL Server?
In this case, will the PBI still supported by Microsoft?
Please kindly clarify.
Thanks.
Solved! Go to Solution.
@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-serv... 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.
@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-serv... 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.
My understanding is that Power BI Report Server is explicitly designed to be on premise, NOT in the cloud. Quite interesting that you want to put that on AWS - what's the reasoning for that?
Same with the database - Report server is a Microsoft solution, and I think they want you to use a Microsoft database.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |