Forum Discussion
Enormous load activity for small Excel file
The report set I'm working with takes as its source a table in an Excel spreadsheet with a few thousand rows of fewer than ten fields. The spreadsheet itself is less than 400KB. The .pbix file is les...
I've had a look at the diagnostics and found two things:
- Four of the 180-odd log entries took up over 80% of the elapsed time;
- Another four took up another 10% or so.
- There was no correlation between elapsed time and resource usage (correlation 0.20 - 0.25. I did like the idea of using PBI to analyse PBI performance data).
There were plenty of others either / both with the same operation or similar stats, so I'm none the wiser at this point.
What I think I'll do next is replace the spreadsheet with a .csv file to see if that makes any difference. And then maybe decompose some of the queries and look at them bit by bit.
- StefanoGrimaldi
Resident Rockstar
if you can, prepare a PBIX file with dummy data without sensitive information and post it here for us to check on the queries itsel and see if we can help an further optmizing it (post also de data file).
