SqlPowerBIRS: New resource proposal

Description

SSRS is basically dead and PowerBI is replacing it. They are literally the same product, except PowerBI can do more. You can still publish reports to the PowerBI RS server. With all that said, it makes sense to basically replace SQLRS.

Proposed properties

Copy and paste from SQLRs, SQLRsSetup and add 1 new parameter. Product.

Product is SSRS or PBIRS. Default is PBIRS.

Another option is to try and figure it out, PBIRS setup for instance is PowerBIReportServer.exe and SSRS is SQLServerReportingServices.exe for install. But maybe PBIRS takes precendence of SSRS. So, PBI would be looked for first and then SSRS.

You can even see here:
PBI (Latest release is 3/28)
https://www.microsoft.com/en-us/download/details.aspx?id=55329

and here
SSRS (Latest release is 2/12)
https://www.microsoft.com/en-us/download/details.aspx?id=55252

Special considerations or limitations

If there are actually differences in RS and PowerBI setup that I am unaware of. The only differences I am aware of are between different versions and setting it up for high availability. The 2 products should be the same in setup and configuration, with different registry values and install locations. This is what the Product option would take care of, to ensure we are looking in the right places.

This will also only cover the version as of today, so SQL 2016+

While we can keep SSRS and PBI separate, the code is the same, so trying to maintain duplicate code isn't ideal, but we could potentially just keep them separate.

Start by reviewing the existing SQLRs and SQLRsSetup resources and comparing their setup and configuration behavior. Determine the differences between SSRS and PBIRS, then define how the Product parameter and product-detection precedence should work. Done means a new resource proposal covering SQL Server 2016+ without duplicating the shared implementation.