Managing larger Office365 document libraries

This morning I ran into an interesting problem.  We have an office365 document library we’re using as a small scale CMS, where users are contributing documents and editing the attributes of those documents.  PowerBI can then query the attributes in that document library to determine what has been contributed, and what is outstanding.  As the project has been successful, we hit the 5000 document mark this morning.  5000 items is the limit for a document library.  Effectively, once you’ve gone over that 5000 item limit, you can no longer sync the library.


This limit is sneaky, as there are no warnings other than viewing the library content.  The report used an OData feed, that never returned an error when the document library was over 5000 items.  It just sat there and never finished.  Anyone who has sync’d their desktop to the document library before it had reached 5000, would have a message in OneDrive for business that reads “We can’t sync this library because it’s too large”, any subsequent files would return the “We’re syncing your files but it’s taking longer than expected“.


It turns out the only way to natively move these files and preserve the attributes, is to copy the files in the sharepoint admin from one document library to another.  If done this way, the attributes will be preserved.  (Don’t copy files via explorer/Onedrive sync).  Alternatively, if you had a document library that was less than 10 meg, you could save it up as a template, and restore it with another name.  That will probably never happen, as the sheer size of the table of contents on 5000 files would itself probably come close to 10meg.

Still looking for an easy solution.  More to come.

Far better an approximate answer to the right question, which is often vague, than the exact answer to the wrong question, which can always be made precise. -John Tukey
The plural of anecdote is not data. - John Myles White

Recent Posts

RSS PowerBI blog

  • New Power BI Premium summary and workload metrics available in the admin portal April 22, 2019
    We have rolled out a new high-level summary metrics experience in the Power BI Admin Portal . This new experience replaces the four summary tiles you previously saw : CPU, Memory thrashing, Memory usage and DirectQuery with wide range of metrics measuring the summary of usage in the last 7 days to better portray the health […]
  • Live now, full session catalog for Microsoft Business Applications Summit 2019 April 22, 2019
    Time to get excited – the full session catalog for Microsoft Business Applications Summit is here. Explore every breakout session and workshop coming to the conference, taking place in Atlanta, Georgia June 10 – 11, 2019. Get ready to flex your skills – and build new ones – with all things Power BI and beyond. […]
  • E-Mail Subscriptions for Paginated Reports is Now Available April 19, 2019
    E-mail subscriptions is one of the key features used by millions of SQL Server Reporting Services customers today. Our latest release for “New Feature Friday” is the support of Paginated Reports in e-mail subscriptions in Power BI. Now, for the first time, you can schedule an e-mail subscription with a PDF attachment of your full […]