Forum Discussion

dniedrauer's avatar
dniedrauer
Resolver I
9 years ago
Solved

Issues connecting to sharepoint credentials error

I have my Power BI Desktop file connected to several text files offline (in folders), but when I try to change the source to pull them off a SharePoint site, I get the error: "We couldn't authenticat...
Need Help
  • dniedrauer's avatar
    dniedrauer
    9 years ago

    I found the solution myself, and it is not very intuitive. There is no "change data source type" option, unfortunately, so this is what you have to do: 

     

    Step 1: import data source (again) from SharePoint as a SharePoint folder. 

    Step 2: go to Advanced Editor and copy data source code. 

    Step 3: go to your original table that points to the locally stored data source and replace the data source code with the new code. 

     

    Voila! It works. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have an odd issue related to this topic. I can connect to a SharePoint list and refreshes with not problems. But, it's when I start applying steps and transforming data in Power Query is when I run into this circle of nonesense; validating credentials and then I get the ever popular "Couldn't authenticate the credentials provided." I've checked the SharePoint setting and there is nothing that sould be causing this problem. 

 

Prodingero's avatar
Prodingero
Helper I
1 year ago

I have the same problem since 2. June 2025.

  • Prodingero's avatar
    Prodingero
    Helper I
    1 year ago

    I have this problem again since 1. July 2025.