Compatibility sharepoint and sharepoint .It take lot of time in updating Excel with 2560 sheets

[mohsin-raza]

Hello:

I have excel workbook with 2560 sheets having same format and save in sharepoint.

It is taking lot of time in updating data in power query ,power bi.

Is it right to save excel file to save in sharepoint?

how to minimize uppdating time? 

[mohsin-raza]

 thanks negi007 in finding the solutuion

[negi007 · Accepted solution]

@mohsin-raza I am not sure how can you reduce loading times with excel having 2560 sheets. But below are some links can guide you

https://blog.crossjoin.co.uk/2018/07/09/power-bi-combine-multiple-excel-worksheets/

https://www.myonlinetraininghub.com/import-multiple-files-containing-multiple-sheets-with-power-quer...

you can also think of merging all sheets into one, try if that works for you.

https://www.ablebits.com/office-addins-blog/2015/09/01/consolidate-excel-merge-sheets/