Forum Discussion
Sharepoint Folder Connection Refresh
If your organization uses Multi-Factor Authentication, it's possible that this could be causing the "Unable to validate credentials" error. Ensure that all team members have completed any required MFA prompts.
Here is the link for your reference:
Enable per-user multifactor authentication - Microsoft Entra ID | Microsoft LearnPlease try to verify SharePoint Access Permissions, double-check that all team members have the necessary permissions not just to access the SharePoint folders but also to view and refresh the data within Power BI. Sometimes, permissions set at the SharePoint level might not propagate correctly to Power BI.
If the issue persists, advise your team members to clear their internet browser cache and then sign in to Power BI with the URL to force an update of their credentials. This step ensures that any cached credentials that might have expired are refreshed.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Have you tried isolating it by just doing a sharepoint folder connection - no other data sources? Also, did you use the root folder of your own sharepoint when connecting to it? It should be something like https://company.sharepoint.com/sites/sharepointsite/ and from there you navigate to the desired folder by filtering the folder path.
Hi danextian,
I have not tried doing only the SharepointFolder connection, this is because we are trying to fully automate using SQL connections, but in some cases we still need the SharepointFolder connection. But I have narrowed it down to that connection being the issue, as we refresh one connection at a time via the Data Pane.
I watched many videos to get the SharepointFolder connection to work, so I beleive I am using the right path. It is https://company-my.sharepoint.com/personal/user_name ..... I am thinking I may be doing something wrong with the "personal" section of the path though. This works in PowerQuery and from there I navigate to the proper folder that my team members all have access to. Yet they still cannot refresh.
