May 15, 2024 at 12:32 pm
Hi
We have an on prem power BI running on a physical SQL2022 enterprise box with SA. Working fine, and legal.
For DR reasons I am considering moving just the web portion of Power BI to a VM and then pointing to the powerbireportserver database on my physical server.
That way if my physical server goes down the webserver will be fine and point to the failed over powerbireportserver DB (via high availability listener).
I think this is doable and legal without having to purchase anything else as we have paid for EE and S/A. Am I wrong?
May 15, 2024 at 1:10 pm
SSRS (And power bi report server is a superset of this) is a licensed feature - as such it requires the server it is installed on to have a valid SQL Server license - so no you can't do that - if you could everyone would setup multiple SSRS servers pointing to the same SQL server instance without having to pay for a license for those servers.
May 15, 2024 at 1:29 pm
Hi
We have an on prem power BI running on a physical SQL2022 enterprise box with SA. Working fine, and legal.
For DR reasons I am considering moving just the web portion of Power BI to a VM and then pointing to the powerbireportserver database on my physical server.
That way if my physical server goes down the webserver will be fine and point to the failed over powerbireportserver DB (via high availability listener).
I think this is doable and legal without having to purchase anything else as we have paid for EE and S/A. Am I wrong?
check this first, it covers licensing, you'd probably need the powerbi premiuim licence which allows hybrid deployments
Also check here
https://learn.microsoft.com/en-us/power-bi/report-server/
It sounds very much like what you're planning is a scaled out report server topology
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2024 at 6:42 pm
Thanks Perry/Fredrico.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply