Forum Discussion

RS_PBI's avatar
RS_PBI
Regular Visitor
3 years ago

Upgrading to latest release - missing Upgrade option

Hi,   I'm currently trying to upgrade a PBI Report Server (15.0.1108.297, MAY 2022, Enterprise) to the latest release - January 2023 (also tried Sept 2022, however same error as below).   When r...
upgrade
RS_PBI's avatar
RS_PBI
Regular Visitor
3 years ago

Ok - so i have compare prod and test environment.

Executed PBI Report Server installation media on prod and it surprisingly offered

me the Upgrade PBI Report Server option instead of Install.

 

Both PBI Report Server Installations look the same from a first point of view including installation directory, version etc. However - i upgrade to SQL Server 2022 on the dev machine! Im not sure but quite optimistic that

this is breaking the Upgrade option.

Can anyone confirm? 

 

What is my option now ? Probably just reinstalling and keeping the report server databaeses etc.

Fine for me if its just that.

v-alipat's avatar
v-alipat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Hi RS_PBI, 

Thanks for reporting the issue 

 

We start looking into it now.  

 

To clarify - you see the Upgrade option in your PROD environment, but not in Dev environment. 

And the difference between two environments is that Dev also has SQL Server 2022 installed? 

Does it have SSRS (SQL Server Reporting Services) installed? 

Does your PROD environment have any of these installed as well? 

  • RS_PBI's avatar
    RS_PBI
    Regular Visitor
    3 years ago

    Thanks v-alipat.

     

    To clarify - you see the Upgrade option in your PROD environment, but not in Dev environment. 

     

    Exactly.

     

    And the difference between two environments is that Dev also has SQL Server 2022 installed? 

     

    Not also. I upgraded SQL Server 2019 in Dev to SQL Server 2022.

    In Prod SQL Server 2019 is still running.

     

    Does it have SSRS (SQL Server Reporting Services) installed?

    SSRS has not been installed in Dev, Prod.

     

    Does your PROD environment have any of these installed as well? 

    No SSRS installed in Prod.

     

    Let me know if i can help with any further information.

    Happy to help.

     

    Thanks