Forum Discussion

Juerg's avatar
Juerg
Regular Visitor
3 years ago
Solved

CPU Consumption issues with SQL Server 2019, Cube and PBI Live Connection

Hi There,  I am in the middle of a SQL Server upgrade project and am migrating PowerBI Reports to the new server. During the migration I noticed that some tiles of the reports are using a lot of CP...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Juerg ,

     

    Please check whether your report has complex logic or applies RLS, you can refer to this post to optimize the report.

    If you have a Premium license, you can use the Premium Capacity Metrics app to track and analyze your CPU.

    You can check out the following posts that may be helpful to you:

    Solved: Complex report dragged SQL Server down to a crawl - Microsoft Power BI Community

     

    If this does not work, then the problem does not seem to be related to Power BI and you should try contacting SQL support for assistance.

     

    Best Regards,

    Neeko Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

     

Juerg's avatar
Juerg
Regular Visitor
3 years ago

Hello Neeko, 

Thank you very much for your reply and the helpful links.

 

In the meantime I found a workaround by identifying the combination measures and dimensions that cause the issue and modified the reports.

Of course this is not an ideal solution but it helps for the moment as only a few reports are affected.

 

As we face this behavior only in the combination of PowerBI Service, Data Gateway and SQL Server 2019 (where the only difference to the old environment is the SQL Server version), I guess the only way forward is (as you also suggest) to contact the SQL support.

Thanks for your help and kind regards,

Jürg