Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Strizzolo
Advocate I
Advocate I

High CPU Usage during GenerateScreenshot activity

Hi,

I have a P2 Gen2 capacity and a series of reports (~1.1GB each) shared on the service. 

The capacity overloads when users do a GenerateScreenshot activity (Track user activities in Power BI - Power BI | Microsoft Docs).

How can an activity like this generate so much problems?

 

Thanks,

1 ACCEPTED SOLUTION
v-xiaoyan-msft
Community Support
Community Support

Hi @Strizzolo ,

 

To enforce CPU throughput limitations, Power BI evaluates the throughput from your Premium Gen2 capacity on an ongoing basis.

Power BI evaluates throughput every 30 seconds. It allows operations to complete, collects execution time on the shared pool physical node’s CPUs, and then for all operations on your capacity, aggregates them into 30-second CPU intervals and compares the results to what your purchased capacity is able to support.

 

Background operations such as dataset and stream refreshing or interactive operations such as querying and report loading can require significant CPU resources, which do not seem to be caused by track activities.

 

Many cases can cause high CPU usage or saturation,This can often be improved by optimizing the model.

Please optimize your data model in the way mentioned in this similar thread:

Optimizing-the-datasource-CPU-usage 

 

Also ,when a dataset is consumed in short bursts of high frequency queries by multiple users (for example, in a training session), resulting in CPU saturation during each burst. 

In some cases, Power BI administrators can request that dataset owners create a less volatile query workload by creating a dashboard (which queries periodically with any dataset refresh for cached tiles) instead of a report. This can help prevent spikes when the dashboard is loaded.

This solution may not always be possible for given business requirements, however it can be an effective way to avoid CPU saturation, without making changing to the dataset.

 

For more information,you can refer to:

Determining whether there is enough CPU 

Suddenly receiving Balance your overloaded Power BI Premium capacity 

 

Hope it helps,


Community Support Team _ Caitlyn

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

View solution in original post

1 REPLY 1
v-xiaoyan-msft
Community Support
Community Support

Hi @Strizzolo ,

 

To enforce CPU throughput limitations, Power BI evaluates the throughput from your Premium Gen2 capacity on an ongoing basis.

Power BI evaluates throughput every 30 seconds. It allows operations to complete, collects execution time on the shared pool physical node’s CPUs, and then for all operations on your capacity, aggregates them into 30-second CPU intervals and compares the results to what your purchased capacity is able to support.

 

Background operations such as dataset and stream refreshing or interactive operations such as querying and report loading can require significant CPU resources, which do not seem to be caused by track activities.

 

Many cases can cause high CPU usage or saturation,This can often be improved by optimizing the model.

Please optimize your data model in the way mentioned in this similar thread:

Optimizing-the-datasource-CPU-usage 

 

Also ,when a dataset is consumed in short bursts of high frequency queries by multiple users (for example, in a training session), resulting in CPU saturation during each burst. 

In some cases, Power BI administrators can request that dataset owners create a less volatile query workload by creating a dashboard (which queries periodically with any dataset refresh for cached tiles) instead of a report. This can help prevent spikes when the dashboard is loaded.

This solution may not always be possible for given business requirements, however it can be an effective way to avoid CPU saturation, without making changing to the dataset.

 

For more information,you can refer to:

Determining whether there is enough CPU 

Suddenly receiving Balance your overloaded Power BI Premium capacity 

 

Hope it helps,


Community Support Team _ Caitlyn

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors