Microsoft 365 Capacity: SharePoint Online & One Drive Boundaries & Limits

Microsoft 365 Capacity: SharePoint Online & One Drive Boundaries & Limits

99 people can have a document open for editing at the same time. If more than 10 people edit a document simultaneously, their edits are more likely to conflict and the user experience will gradually degrade.

You’ve Got Millions of Documents – Now What?

We’re designing Digital Workspaces for a fun new Microsoft 365 Consulting engagement. Small public company with a bright future – they will be growing fast. Having already accumulated several million documents on their shared drives, they need a better way to: reduce clutter; more readily find their data; standardize their data collection practices; and share information within the firm according to strict governance patterns.

Roadmap

In putting together the 5 year roadmap, it’s important to architect a solution that will not only deliver value today, but also scale well into the future. The likelihood of remaining on Microsoft 365 for the next 10+ years is high so this isn’t your typical 5yr business system. Our investment in planning should mitigate our technical debt resulting in a system that can deliver value far past its expiry date.

SharePoint Online / One Drive Boundaries & Limits

The SharePoint Online & One Drive for business Boundaries & Limitations article is an invaluable resource in planning your topology:

This article describes some important limitations that you might need to know for different SharePoint Online plans in Microsoft 365. For example, it provides information about number of supported users, storage quotas, and file-size limits. This article covers the limits for paid subscriptions.

SharePoint Online Boundaries & Limits

Capacity Planning

Capacity Planning is an essential step in determining how long your investment in Microsoft 365 will last. If you are moving to Microsoft 365, and want to make sure you’re making intelligent decisions, please reach out for a Microsoft 365 Consult.

Recent Insights

Microsoft 365 Capacity: SharePoint Online & One Drive Boundaries & Limits

We’ve got two official languages in Canada: French & English. SharePoint Online Multilingual Support plays an important role in presenting the right language to the right user. In this blog post we outline the features, and some of the challenges we’ve faced in building Modern Multilingual SharePoint Online sites.

read more

Excel Workbook with SharePoint Search Power Query

Excel Workbook with SharePoint Search Power Query

I’ve been using Power BI & SharePoint Search to aggregate and report on SharePoint project data recently. If you haven’t already read Connecting Power BI to SharePoint Search (for Managed Metadata & Aggregate List Support) it may be worth a read to get up to speed on the details of this particular power query.

I’ve been using Power BI & SharePoint Search to aggregate and report on SharePoint project data recently. If you haven’t already read Connecting Power BI to SharePoint Search (for Managed Metadata & Aggregate List Support) it may be worth a read to get up to speed on the details of this particular power query.

We’ve uploaded an Excel Workbook to GitHub containing the SharePoint Search Power Query. You’re going to need to ensure you’ve signed up for Power BI at http://www.powerbi.com and connected with your O365 tenant. You also need to download and install the most recent version of Microsoft Power Query for Excel (Workbook created with Version: 2.24.4064.242).

Download Excel Workbook with SharePoint Search Power Query from GitHub

To use this workbook, enter all parameters, click on the Power Query Ribbon Tab, click the Show Pane button, and refresh the SearchResults Data Source, click on the SearchResults worksheet. The workbook takes three parameters:

Search Keywords: You can add any search expression here, it will be appended to the SP Search REST call. As all results will be returned please make sure to constrain this to a reasonable #.

Tenant URL: Your Office 365 Tenant URL (or URL to a specific site collection). You’re going to have to authenticate using your O365 Organizational Profile as follows:

Step 1) You may first be prompted to use Anonymous authentication. As you want to protect your organizations data, select Organizational Account at the bottom of the green bar on the left.

Step 2) Organizational account should now be highlighted. Click the Sign In button to open O365 Sign-In Screen.

Step 3) Sign in with your Office 365 Credentials.

Step 4) Set the privacy level of data in this workbook to Organizational and click Save.

Metadata Properties: These are the columns you would like to return in the search results. Columns should be comma delimited with no spaces.

I hope you enjoy the workbook. With Search being a huge cornerstone in O365, I’d love to hear more about how you’re using this in your unique Office 365 Scenario (Delve,Exchange,SharePoint etc.)!

If you need any help or want a Power BI Consult to see how you can unlock the power of data within your organization please reach out!

If you are looking to have this run on Power BI Online please see the follow-up work by Paul Keijzers at Connect Power BI Online to SharePoint Search using REST.

Recent Insights

Microsoft 365 Capacity: SharePoint Online & One Drive Boundaries & Limits

We’ve got two official languages in Canada: French & English. SharePoint Online Multilingual Support plays an important role in presenting the right language to the right user. In this blog post we outline the features, and some of the challenges we’ve faced in building Modern Multilingual SharePoint Online sites.

read more