Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Shantanu1
New Member

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.

1 REPLY 1
Adescrit
Impactful Individual
Impactful Individual

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.


Did I answer your question? Mark my post as a solution!
My LinkedIn

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.