News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... I am trying to do a Ex...

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

Suggested answer

I am trying to do a Export excel.

(4) Share

Report

Report

Posted on by Dyavari Sandeep Yadav

112

So this is working perfect. But I am getting an error when the Onedrive is setup in the business central

So, I tried to debug the issue, at last I got to know that this is because of Onedrive setup. but I am unable to troubleshoot it.

In openExcell line its triggering the error.

So when its trying to get the Default Location, its getting an error

In debugging I got the ResponseErrorDetails

'{"error":{"code":"BadRequest","message":"Current authenticated context is not valid for this request. This occurs when a request is made to an endpoint that requires user sign-in. For example, /me requires a signed-in user. Acquire a token on behalf of a user to make requests to these endpoints. Use the OAuth 2.0 authorization code flow for mobile and native apps and the OAuth 2.0 implicit flow for single-page web apps.","innerError":{"date":"2025-04-21T13:02:48",".........

this is the call stack

Can anyone help me or any suggestions , how can we troubleshoot this issue.

Categories:

Dynamics 365 Business Central

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Khushbu Rajvi. 16,372 Super User 2025 Season 1 on at

Like (3)

Report

I am trying to do a Export excel.

Hope this helps as well: https://businesscentralgeek.com/7-excel-tips-for-business-central

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-excel-buffer

https://www.youtube.com/watch?v=jalKh9tSAjg
Suggested answer

Jainam M. Kothari 7,938 on at

Like (2)

Report

I am trying to do a Export excel.

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/admin-onedrive-integration-onpremises

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-onedrive-integration
Suggested answer

YUN ZHU 83,249 Super User 2025 Season 1 on at

Like (2)

Report

I am trying to do a Export excel.

Hi, hope the following helps.

Dynamics 365 Business Central: How to use Excel Buffer to Export data

https://yzhums.com/4180/

Thanks.

ZHU

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

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

#1

Sohail Ahmed 1,014

#2

YUN ZHU 950 Super User 2025 Season 1

#3

Mansi Soni 624

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans