Small and medium business | Business Central, N...

Failed to acquire an access token while exporting to Excel

(0) Share

Report

Posted on by Student

103

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.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Rob F. 503 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Rob F. 503 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

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

Hope this helps as well.

Thanks

ZHU

Was this reply helpful? Yes No
Rob F. 503 on at

Like (0)

Report

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.

Was this reply helpful? Yes No