Forum Discussion
Credential issues in Power BI connecting to SharePoint based excel spreadsheet
If anyone is struggling with this same issue, I ended up figuring out a solution from within Power BI desktop:
1. Going to File > Options and settings > Options.
2. Under the GLOBAL menu, going to Security, and scrolling down to Authentication Brower and check the box for Use my default web browser.
Then I refreshed my data and was able to connect SharePoint as a data source.
Hello again amitchandak ,
A quick follow-up,
There was another case I had last week and was experiencing the same issues. I was able to connect a data source from SharePoint to Power BI. It was refreshing the data and I had no problems. However, the next day, everything changed. I was unable to refresh the data an ran into the same error, "We're unable to connect. Please delete your credentials and try again later"
I just revisited this case to try and clear the permissions in the data source setting, nothing seems to happen:
And when I try to specify my credentials I receive this notification:
Any help at all would be much appreciated!
