Slow loading of data

[Shantanu1]

Hi,
I'm facing the issue everytime I make some changes the excel input sheet it takes a lot of time in loading once I hit refresh all option.
I've upgraded my laptop that has 16GB of RAM and 4GB of Graphics Card, still no impact.

Generally, I use unpivot column option for analysis and makes over 30 tables using unpivot option based on different data columns.

If possible, can someone let me know how to resolve the issue and why this issue is occuring repeateadly.

[Adescrit]

Hi @Shantanu1 

Do each of your 30 tables use the same Excel tables as a Source? If so, you could try creating one "staging" table that loads the Excel data into your model once, and then use referencing  to use the staging table as a source for all 30 tables.