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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Efficiency - Multiple Excel Files vs One file multiple sheets / tabs

Hi

 

Using Excel files in Sharepoint, is it more efficient to import from multiple Excel files or from one file with multiple tabs? Or is there no practical difference?  I'm talking about 12-15 tables. 

 

I have no current issues, but I want to avoid possible future problems, and I just prefer to use the more efficient method if one exists.

 

TIA

 

Primo

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @Anonymous,

I think get data from one file should be better, you only need to get data from one source file, then you can duplicate the query table and change the navigate steps to redirect to different sheets.

It also helps you to reduce maintain time and you only need to handle one data source file.

Regards,

Xiaoxin Sheng

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi Xiaoxin Sheng

thanks for the reply, that sounds like good advice. I had wondered if there was a hit in terms of time to load for using multiple files, or a bottleneck for using multiple sheets in one file, but I guess it's not significant - I haven't seen any noticeable problems with either method. So I'd agree that from a development and maintenance point of view using one file is a more practical solution.

 

Thanks again for your help

 

Primo

Anonymous
Not applicable

HI @Anonymous,

I think get data from one file should be better, you only need to get data from one source file, then you can duplicate the query table and change the navigate steps to redirect to different sheets.

It also helps you to reduce maintain time and you only need to handle one data source file.

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.