Power Query Refresh Fails with SharePoint 500 Internal Server Error

harish1199 0 Reputation points
2026-05-14T17:45:25.99+00:00

Hi everyone,

I am facing the below error while trying to refresh a Power Query in Microsoft Excel:

[DataSource.Error] SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.)

Scenario:

  • The Power Query is connected to an Excel file hosted on a SharePoint site.
  • The data source, file path, and query steps are all correctly configured.
  • The same query works without any issues for another user using the same setup.

Issue Details:

  • The error consistently appears when I attempt to refresh the query.
  • I have access to the SharePoint site and the file, and can open/edit it without issues.

What I’ve Tried:

  • Re-authenticating data source credentials
  • Clearing permissions in Data Source Settings and reconnecting
  • Reconnecting to the SharePoint file

None of the above has resolved the issue.

What could be causing this 500 error during Power Query refresh in SharePoint?

Are there any known issues or checks I might be missing on the Excel or SharePoint side?

Any suggestions or troubleshooting steps would be really helpful.

Thanks in advance!

Microsoft 365 and Office | SharePoint Server | For business
0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-05-14T17:45:51.1466667+00:00

    The error indicates a failure when Excel (Power Query) calls the remote SharePoint service during refresh. A 500 Internal Server Error is a server-side failure, but from the Excel/Power Query side there are several common causes and checks:

    1. Check the data source path and availability
      Even if the file can be opened in the browser, the path used by Power Query must still be valid and accessible:
      • In Excel, go to Data > Get Data > Data Source Settings.
      • Select the SharePoint connection and verify the URL and file path are correct and still exist.
      • If the file was moved, renamed, or the library structure changed, update the path using Change File Path and then select Get Data again.
    2. Verify credentials and permissions
      Power Query uses its own stored credentials, which can differ per user:
      • In Data Source Settings, select the SharePoint connection and choose Clear Permissions.
      • Reconnect and provide the appropriate authentication method and credentials when prompted.
      • Ensure the account used has at least read access to the SharePoint site, library, and file. A subtle permission difference between users can cause one user to succeed and another to fail.
    3. Handle data source errors systematically
      Power Query distinguishes between local and remote errors. A 500 error is a remote error from the SharePoint service:
      • Retry the refresh later in case of intermittent service or network issues.
      • Confirm with the SharePoint administrator whether there are changes to the site, maintenance, or throttling that might affect requests.
      • Check if there were changes to authentication (e.g., conditional access, MFA, or privacy settings) that might block the request for one user.
    4. Check for locked or open files
      If the target Excel file on SharePoint is open or locked (for example, by another user or in a non-subscription version of Excel), the refresh may fail:
      • Ensure the source file is saved and closed.
      • If someone else has it open, ask them to close it or check it in.
    5. Compare configuration with the working user
      Since another user can refresh successfully:
      • Compare the Data Source Settings between both users (URL, authentication method, privacy level).
      • Ensure both are using the same version of Excel and Power Query features.

    If the issue persists after these checks, the next step is to involve the SharePoint administrator to review server logs for the 500 error and confirm there are no server-side issues or restrictions affecting this specific user or request pattern.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Hin-V 16,830 Reputation points Microsoft External Staff Moderator
    2026-05-14T19:16:55.8566667+00:00

    Hi @harish1199

    Thank you for sharing your concerns. 

    Based on my research, looks like the error message “(500) Internal Server Error” usually indicates that the request sent by Power Query to SharePoint is failing on the server side, rather than being caused by an issue with your query configuration or Excel file. Since the same query works for another user in your organization, this strongly suggests a user-specific issue rather than a problem with the data source itself. Power Query maintains its own stored credentials and connection context, which can vary between users even when they are accessing the same SharePoint file. 

    You may refer to the solution provided by Q&A Assist and follow these steps below: 

    Reconnect Using the Proper SharePoint Connector  

    Go to Data > Get Data > From File > From SharePoint Folder. 

    Paste only the site URL (for example, your SharePoint site link, not the full file path). 

    Then, sign in using your Organizational account. After connecting: Go to Data > Queries & Connections > Right-click your query > Edit.

    Navigate to Home > Data Source Settings.

    Clear Permissions for all SharePoint entries again. 

    Refresh the query and try again to see if the issue still persists. 

    Check and clean the source path 

    Ensure the Source step uses a clean SharePoint URL.  

    Avoid URLs containing parameters such as ?web=1. 

    Ensure the query is not referencing any local path. 

    Additionally, you could try closing Excel completely and reopening it. Then, test with a new blank workbook and recreate the query from scratch or compare your setup with a working user’s version to identify any differences. 

    Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution. 

    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.   

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.