cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

High CPU Utilization when user export data from report with SSAS Live Connection

Hi all,

 

I have facing this issue for some times now.

 

My setup is using SSAS Live Connection for my reports and publish to Power BI service. The problem is, my users sometimes like to drag some big table listing report and export them out. Whenever they do this, my server CPU utilization shoot up to 90% and above. 

 

Is there any ways that I can optimize this? I do not want to remove that export data functionality for my users.

 

Thanks in advance.

 

Max

1 REPLY 1
Community Champion
Community Champion

Whats more important to your users, up to the minute data, or flexiability of access?

 

If the data exporting is the main desire, but they are happy for the data to be stored and refreshed at intervals, then I would suggest moving to an import model and creating a set of tables that have whatever you need.  This gives you the option of keeping the data tight and optimised.

 

If they need data using the direct query method, then you are much more limited in what you can provide.  I would next suggest looking into another database that acts as a mirror of your source.  This would let you either distribute or isolate the reporting performance to other servers.

(I no longer have access to this account)

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors