Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Export Summarized Data to xlsx with Live Connection Taxing Capacity

We are having issue where users exporting summarized data from a matrix is taxing the capacity and fails. This is an activity they do regularly without issue. Today every time they try, it taxes our ...
Need Help
Redriver123's avatar
Redriver123
Frequent Visitor
2 years ago

We are on P1 capacity and we have experienced the same issue. User exported table using "live connection" export option and this has drained our premium capacity resources.

As admin, I think we need to disable this option and look for alternative to export large volume of data.

One option I can think of is asking them to use a slicer and reduce the export size to multiple exports and to stay within a limit of 150k rows.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    How are these activities coming through on the Premium Capacity Metrics App?  "XMLA Read operation" ?

    • Redriver123's avatar
      Redriver123
      Frequent Visitor
      2 years ago

      yes, but what's causing actual Spike is the related Query usage ... (ofcourse, there's a chance that it may be an underlying issue withing the relationship between 2 tables in the model that it's querying during export... maybe it's creating a back-end virtual instance, with live connection and uses DirectQuery?) Hope this bit of info helps.