Forum Discussion

Shantanu1's avatar
Shantanu1
New Member
2 years ago

Slow loading of data

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.

data protection

1 Reply

  • Adescrit's avatar
    Adescrit
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    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.