Forum Discussion

josef78's avatar
josef78
Memorable Member
3 years ago

Power BI Report Server September 2022 Issues

Hello everyone, I want to ask, who you are using September 2022 release of Report Server in a test or production environment, if you register any problems or other unexpected behavior, please list t...
Issues
v-alipat's avatar
v-alipat
Microsoft Employee
3 years ago

Hi everyone! 

 

Power BI Report Server September 2022 QFE build is now available! It has fixes for ODBC refresh, custom visuals, weekday schedule, and some more changes. Changelog will be updated soon ðŸ˜Š 

 

  • Gemw87's avatar
    Gemw87
    Frequent Visitor
    3 years ago

    Since upgrading to September 2022 QFE build the CPU on our production server is now at 97%, before the QFE build and busiest periods saw CPU at 65% max.

     

    Can you advise? v-alipat 

    • v-alipat's avatar
      v-alipat
      Microsoft Employee
      3 years ago

      Hi Gemw87 

      We don't observe such consumption changes in any of our test machines, are you sure it's the Report Server process that is taking more now? 

      Also, do you see it with just one machine or more than one? and could you please specify any computer specifications with which you see it? 

       

      Thank you 

      • Gemw87's avatar
        Gemw87
        Frequent Visitor
        3 years ago

        We are seeing this on our production report server, this has only started to occur since we applied the latest September 2022 QFE last week. Prior to that we never saw the CPU this high.

         

        Upon investigation we're finding that some of the larger reports (150 MB report) when refreshing are causing the report server CPU to hit 100%. This wasn't occurring prior to the latest update. 

         

        The top processes when hitting 100% are Microsoft SQL Server Analysis Services, Microsoft Mashup Evaluation Container and WmiPrvSE.exe

         

        The report server spec is -

        * Windows Server 2016 Datacenter

        * Processor - Intel(R) Xeon(R) CPU E5-2698 v3 @ 2.30GHz (4 processors)

        * Installed RAM - 12 GB

        * System type - 64-bit OS, x64-based processor

         

        Can you please advise?