Graph API suddenly did not working for Personal Microsoft Account

Tiger Ng 5 Reputation points


My app's account type on Azure Portal is

"Accounts in any organizational directory (Any Azure AD directory - Multitenant) and personal Microsoft accounts (e.g. Skype, Xbox**)"**

My app is using Graph API to access workbooks. It is running properly for Personal Microsoft Account until last day. It prompts error:

"Could not obtain a WAC access token"

WAC is related to SharePoint. However, I am using Personal Microsoft Account for authorisation.

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
855 questions
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
284 questions
Microsoft Graph Workbooks API
Microsoft Graph Workbooks API
A Microsoft API that allows web and mobile applications to read and modify Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive.
61 questions
1 vote

2 answers

Sort by: Most helpful
  1. John Max 5 Reputation points

    The error message you are receiving suggests that there may be an issue with obtaining a WAC (Web Application Companion) access token for your Personal Microsoft Account. WAC is related to accessing and editing documents on SharePoint.

    To troubleshoot this issue, you may want to try the following steps:

    1. Verify that the SharePoint site you are trying to access is accessible and that you have the necessary permissions to view and edit the document.
    2. Check if there have been any changes to the SharePoint or Office 365 environment that could affect your access.
    3. Verify that your app has the necessary permissions to access the SharePoint site. You may need to check the permissions your app has been granted in the Azure Portal.
    4. Check if your app is correctly configured to use the correct endpoints and scopes for accessing the Graph API and SharePoint.

    You may also want to check if there have been any updates or changes to the Graph API that could be affecting your app's ability to access the workbook.


  2. Zehui Yao_MSFT 3,791 Reputation points Microsoft Vendor

    Hi Tiger Ng, I could reproduce this issue when the excel file is .xls extension.

    As according to the documentation, the Excel REST API supports only Office Open XML file formatted workbooks. The .xls extension workbooks are not supported. So please check the extension of your file. Hope this helps. Best Wishes.

    User's image

    User's image

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.