web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Failed to acquire an access token while exporting to Excel

(0) ShareShare
ReportReport
Posted on by 105
Hi 
When I try to hit export button on any page it askes me for user name and once provided it throw an eror that 

Failed to acquire an access token.

pastedimage1662139287236v1.png

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    What release of BC is this? Cloud or OnPrem, if OnPrem what is the CU release. Best is probably to raise this issue via your partner to Microsoft as there are a few settings that may need adjustments.

    Thank you.

  • Rob F. Profile Picture
    522 on at

    Hi, our users have started to get the same prompts and cannot use Open in Excel.  We are on BC Cloud latest version.  Marco Mels  any idea what settings need to be changed?

  • Suggested answer
    Rob F. Profile Picture
    522 on at

    We had originally setup this SharePoint configuration so that the opened files would save to user's OneDrive folder, following this blog post:

    Dynamics 365 Business Central: Microsoft SharePoint Connection Setup page (Open Excel in Sharepoint and OneDrive) | Dynamics 365 Lab (yzhums.com)

    Our partner advised to delete this configuration and that resolved the issue for us, although we lost the functionality to save directly to OneDrive and now the Excel files just download to user's computer instead.

    pastedimage1662497438127v1.png

  • Suggested answer
    YUN ZHU Profile Picture
    102,079 Super User 2026 Season 1 on at

    Hi, just adding some info.

    "As part of this change, we are announcing deprecation of the legacy SharePoint Connection Setup page and SharePoint integration capabilities."

    https://docs.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/configure-onedrive-integration

    pastedimage1662539795199v1.png

    Hope this helps as well.

    Thanks

    ZHU

  • Rob F. Profile Picture
    522 on at

    Thank you Zhu, that makes it more clear.  It would appear that the SharePoint feature has been deprecated in the current version, before the new OneDrive Setup becomes available in the next release.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,713 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,032 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 914 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans