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

[maximus8557]

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

[Ross73312]

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.