Managing OneDrive integration with Business Central

This article provides an overview of what an administrator can do to control OneDrive for Business integration with Business Central. Business Central online customers benefit from automatic integration with no extra setup required to use the open and share in OneDrive features. With the OneDrive Setup assisted setup guide, you can give users access to even more OneDrive features, like opening Excel file in OneDrive—or even turn off all features.

Configure OneDrive for integration with Business Central

This section discusses requirements that must be met in OneDrive for Business to configure the integration with Business Central and task you can do to manage the integration.

Minimum requirements

  • Each user must have a license for Business Central and OneDrive as part of a Microsoft 365 plan.
  • OneDrive must be set up for each user.

Managing privacy

Important

If you've chosen to deploy Business Central and OneDrive to different countries or regions, the files generated by Business Central and placed in OneDrive may cross data residency boundaries. Make sure to confirm your organization's policies and government compliance requirements for data residency before enabling the connection to OneDrive.

Administrators and end users control the content stored in OneDrive, and this data is owned solely by your organization. Learn more in How SharePoint and OneDrive safeguard your data in the cloud. You can also visit our Microsoft Privacy Statement, which explains the data that Microsoft processes, how Microsoft processes it, and for what purposes.

By enabling this service connection, you agree:

(a) to share data from Dynamics 365 Business Central with the service provider, who will use it according to its terms and privacy policy; (b) the compliance levels of the service provider may be different than Dynamics 365 Business Central; and (c) Microsoft may share your contact information with this service provider if needed for it to operate and troubleshoot the service.

Configure Business Central

With Business Central online, the connection between Business Central and OneDrive is automatically configured for you. App features, such as Open in OneDrive and Share, are available by default. System features, such as opening list exports in Excel for the web, aren't turned on by default. Use the OneDrive Setup assisted setup guide to change these options.

Configuring Business Central on-premises is different because the connection between Business Central and OneDrive isn't configured for you. You'll have to do it manually. Learn more in Configuring OneDrive Integration with Business Central On-premises.

About multiple environments

OneDrive integration is configured per environment, that is, your settings will apply to all companies in that environment. If your organization has more than one environment, you'll have to configure OneDrive integration for each.

Prerequisites

  • Read permission and at least indirect insert, modify, and delete (imd) permission on table Document Service Scenario

Configure OneDrive using OneDrive Setup

  1. Select Search (Alt+Q) in the upper-right corner, enter OneDrive Setup, and then choose the related link.

  2. Select Next. If the Your privacy page appears, read the information and, if you agree to the terms, choose Agree to continue.

  3. On the Configure OneDrive file handling page, you have the following options to choose from:

    OptionDescription
    Use with app featuresIf you turn on this option, the Open in OneDrive and Share actions are made available on files in Business Central, like files attached to documents or in the Report Inbox. These actions let users copy, open, and share files in OneDrive. <ul><li>Business Central features that store or capture documents and other files, and offer Open in OneDrive and Share actions to bring those files out of Business Central, such as Incoming Documents and record attachments.</li><li>Line of business features that generate custom Excel workbooks, such as Sales Budgets.</li><li>Reports sent to the Report Inbox.</li><li>If you have installed any customizations or extensions, these may add more features that use OneDrive.</li></ul>For more information, see Opening and Sharing Business Central Files in OneDrive.
    Use with system featuresTurning on this option activates the following features:<ul><li> The Open in Excel and Edit in Excel actions on list pages will automatically copy the Excel file to OneDrive, then open it in Excel Online. For more information, see Viewing and Editing in Excel.</li><li> Sending a report to an Excel or Word file will automatically copy the file to OneDrive, then open it in Excel or Word online. For more information, see Saving a report to a file.</li></ul>
  4. Choose Next > Done.

Completing the guide agrees to the OneDrive privacy notice. If you have permission to approve notices for the organization, that approval applies to all users. Otherwise, it applies only to you. To let users decide individually, an administrator can go to Privacy Notices Status and select Let User Decide for OneDrive. Learn more in Privacy notices.

Switching to new OneDrive integration after upgrade

The OneDrive Setup assisted setup was introduced in 2022 release wave 2, version 21.0. It replaces the legacy SharePoint Connection Setup. Use OneDrive Setup to manage the OneDrive features that are accessible to users.

To switch, open and run the OneDrive Setup assisted setup as described in the previous section. If a legacy connection is detected, the guide explains which settings will change. Business Central doesn't notify users about these changes, so let users know before you switch.

Restoring OneDrive and Business Central

As part of a disaster recovery exercise, administrators might need to restore a Business Central online environment to a backup from a time in the past, and synchronize OneDrive storage to that same point in time. OneDrive provides recovery various tools, such as restoring a user’s OneDrive to a previous time, restore a previous version of an individual file, or restore deleted files. Learn more in the following articles:

Governance

The SharePoint admin center provides extensive control over policies that govern the use of OneDrive throughout the organization. Users who have at least the SharePoint administrator role can set up policies that determine who can access OneDrive, where data resides, the content lifecycle, and much more. The following links provide information about often-used features and settings that may enhance your integration with Business Central.

Note

Some features may be available only for specific plans.

Business Central and OneDrive for Business Integration
Opening Business Central Files in OneDrive
OneDrive FAQ

Find free e-learning modules for Business Central here