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 found a solution to this:
- Go to File in the top left corner
- Options and settings
- Options
- Under the Global tab, go to Security
- Scroll down and enable "Use my default web browser"
Then try again to connect to your Sharepoint site and it should open a tab in your default browser after which you should be able to sign in.
I hope this helped someone!