Skip to main content

Notifications

Announcements

No record found.

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 103
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

  • Rob F. Profile Picture
    487 on at
    RE: Failed to acquire an access token while exporting to Excel

    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.

  • Suggested answer
    YUN ZHU Profile Picture
    85,629 Super User 2025 Season 1 on at
    RE: Failed to acquire an access token while exporting to Excel

    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

  • Suggested answer
    Rob F. Profile Picture
    487 on at
    RE: Failed to acquire an access token while exporting to Excel

    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

  • Rob F. Profile Picture
    487 on at
    RE: Failed to acquire an access token while exporting to Excel

    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
    Marco Mels Profile Picture
    on at
    RE: Failed to acquire an access token while exporting to Excel

    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.

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans