Updating PBIRS - SQL Server Enterprise with Software Assurance edition
Hi to all, Where I work we are currently using the January 2020 version of PBIRS and we want to upgrade to a newer version. We have the SQL Server Enterprise with Software Assurance edition. I tried to upgrade following the steps described in this link (https://docs.microsoft.com/en-us/power-bi/report-server/upgrade) using the October 2020 installation file but encountered an error in the process. Here is an extraction of the installation log file: [32A4:5544][2020-12-28T21:23:13]i000: Setup: Install Started for package Microsoft Power BI Report Server [530C:4A6C][2020-12-28T21:23:13]i301: Applying execute package: PBIReportServerSetup, action: Install, path: C:\ProgramData\Package Cache\{BC4FF963-E964-471C-BDBD-5856378D7CFD}v1.9.7627.11028\PBIReportServerSetup.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" INSTALLFOLDER="H:\Microsoft Power BI Report Server" SKU="PbirsSqlServerEeSa" CHANGEEDITION="False"' [32A4:5544][2020-12-28T21:25:04]e000: UnexpectedError: Burn engine encountered error. PackageId: PBIReportServerSetup, ErrorType: WindowsInstaller, ErrorCode: -2147483648, Data: , ErrorMessage: Something went wrong, please find details in setup logs., UIHint: 0 [32A4:5544][2020-12-28T21:25:04]i000: User: Error: Microsoft Power BI Report Server: Something went wrong, please find details in setup logs. [32A4:5544][2020-12-28T21:25:04]e000: UnexpectedError: setup failed for packageId: PBIReportServerSetup, package: Microsoft Power BI Report Server, errorCode: -2147483648, errorMessage: Something went wrong, please find details in setup logs. [32A4:5544][2020-12-28T21:25:04]i000: Setup: Install Completed for package Microsoft Power BI Report Server [32A4:5544][2020-12-28T21:25:04]i319: Applied execute package: PBIReportServerSetup, result: 0x0, restart: None [530C:4A6C][2020-12-28T21:25:04]i325: Registering dependency: {a13404d5-ce1c-49a7-884b-6f7211f2f602} on package provider: {BC4FF963-E964-471C-BDBD-5856378D7CFD}, package: PBIReportServerSetup [32A4:5544][2020-12-28T21:25:04]i000: Setup: Install Started for package {0a65872d-69dc-4386-af80-8a708f7c3fa7} [530C:4A6C][2020-12-28T21:25:04]i301: Applying execute package: {0a65872d-69dc-4386-af80-8a708f7c3fa7}, action: Uninstall, path: C:\ProgramData\Package Cache\{0a65872d-69dc-4386-af80-8a708f7c3fa7}\PowerBIReportServer.exe, arguments: '"C:\ProgramData\Package Cache\{0a65872d-69dc-4386-af80-8a708f7c3fa7}\PowerBIReportServer.exe" -uninstall -quiet -burn.related.upgrade -burn.ancestors={a13404d5-ce1c-49a7-884b-6f7211f2f602}' [32A4:5544][2020-12-28T21:25:10]i000: Setup: Install Completed for package {0a65872d-69dc-4386-af80-8a708f7c3fa7} [32A4:5544][2020-12-28T21:25:10]i319: Applied execute package: {0a65872d-69dc-4386-af80-8a708f7c3fa7}, result: 0x0, restart: None [32A4:5544][2020-12-28T21:25:10]i000: Setup: Package action completed. [32A4:5544][2020-12-28T21:25:10]i000: Setup: A restart is required. [32A4:5544][2020-12-28T21:25:10]i052: Condition 'RebootPending = 0' evaluates to true. [32A4:5544][2020-12-28T21:25:10]i000: Setup: Checking IsRebootPending() = False [32A4:5544][2020-12-28T21:25:10]i000: User: Bundle action completed with errors, please fix the issue then try repair. [32A4:5544][2020-12-28T21:25:10]i399: Apply complete, result: 0x0, restart: Required, ba requested restart: No What might be the problem with the installation? Is this the right way to do it given that we have the PBIRS SQL Server Enterprise with Software Assurance edition? Thanks in advance, best regards.
PBI Report Server without BPI Premium licensing requirements
Assuming I want to work towards the "small" variant of the proposed "best practice" four-server topology of Power BI Report Server. 1 Enterprise Edition SQL + SA requirement: which virtual machines would require a SQL EE + SA ? Or none at all in case a SQL EE+ SA with 8 cores and 32GB already exists somewhere else in my organisation? Would SQL Standard in terms of functionality be sufficient for the rest of the virtual machines? 2 PowerBI Pro license requirement: the EULA mentions "A Power BI Pro User SL is required to publish shared Power BI reports using the Power BI Report Server". What triggers me is the "shared" part. Would this mean that users that don't share published reports (e.g. by using the "My Folder") are in line with the EULA as well? I assume admins can still see these reports so in that sense they would still be "shared" in a way.... Thx for helping me out.
