Forum Discussion
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...
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.
I had the same issue. Can't even believe I found a forum post that solves exactly my problem.
Thanks!