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. 

     

Anonymous's avatar
Anonymous
Not applicable
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.