This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 22%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Originally, I created a dashboard in excel using power query and power pivot, which get data source from the organization's sharepoint, which works fine until 9 July 2026 ,My file unable to sign in to refresh data and there is a notification as shown in the picture. How to fix it?
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 32%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Same problem we are facing in our organization , it was working fine untill last 2 week and suddenly getting this error.We are unable to connect to sharepoint folder from excel using powerquery.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
You can review the discussion below, and if your situation is the same, you can reach out to Microsoft Support for assistance.
If your scenario is different, I recommend creating a new thread and including the relevant details there. This helps avoid mixing multiple issues in a single discussion and allows moderators to focus on your specific case more effectively.
Creating a separate thread will also allow us to request additional information via private message if needed, while helping to protect any personal or organizational data you may need to share.
Thank you for your understanding.
Hi Pang
According to my research based on the messages shown, the issue appears while Excel is attempting to connect to the SharePoint data source. The screenshots reference Microsoft sign-in pages and authentication-related URLs, which may indicate a problem with the authentication process or stored credentials used for the SharePoint connection
You can try the following:
For your information: Refresh an external data connection in Excel | Microsoft Support
If the issue persists, could you please share some information:
For your reference: Power Query Refresh Fails with SharePoint 500 Internal Server Error - Microsoft Q&A
I hope this information helps and look forward to your response!
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.
Previously, I tried all the suggested solutions, but the issue persists. Even after creating a new workbook and attempting to pull data from SharePoint, the same problem occurs.
Q: Can the affected account access the source SharePoint site directly in a web browser?
A: Yes, it affects all users.
Q: Can the affected account access the source SharePoint site directly in a web browser?
A: Yes. Both the data source files and the dashboard files can be accessed via a web browser, though users have limited access permissions.
Q: Did the issue start after a password change, MFA change, Conditional Access policy change, or Office update?
A: The issue occurred with some files before the password change, and with others after the change.
Hi Pang
Thank you for your response.
Based on the information provided, the issue is occurring in Excel 2019 when connecting to SharePoint data sources through Power Query/Power Pivot, and the same behavior is reproduced in newly created workbooks across multiple users.
Additional details that may be helpful in determining whether the behavior is related to the SharePoint environment or the connection method being used:
The screenshots show sign-in related messages rather than a specific Power Query or Power Pivot refresh error. Information about the SharePoint environment and connection method may provide more insight into why Excel is unable to establish the connection while the same files remain accessible through a web browser.
Hi Hani-Ng
Thank you for your attention
Issue Onset Timeline:
Hi Pang
Thank you for your update.
Since the issue affects multiple users and multiple workbooks, and browser access to SharePoint remains available, it may be necessary for the Microsoft 365 administrator to review Microsoft Entra ID sign-in logs and SharePoint Online authentication settings around the time the behavior began.
If no recent changes, opening a support case with Microsoft 365 Support team may be the next step. Given that the behavior occurs across multiple users, multiple workbooks, and multiple SharePoint Online sites, the information available so far does not point to a single workbook or query configuration as a common factor. Additional investigation of the Microsoft 365 and SharePoint Online environment may be required.
To summit support ticket (for admin account only), you can see: Get support - Microsoft 365 admin | Microsoft Learn