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.
Super UserAnonymous , Hope you already tried?
Clear permission in data source setting
Hello amitchandak ,
Thanks for reaching out!
I am unable to connect the data source to Power BI, so there are no data source files to clear permissions. Would I clear permissions from SharePoint?
Here is some additional background info, if it is helpful...
So I am trying to access a dataset from shared SharePoint folder were I was granted permission to edit. I'm not sure if I need special permissions to connect to Power BI, or how to access that option, if it exists.
To test this I created my own SharePoint page, folder, and then a test excel spread sheet. On this page I am the "owner" but when I attempted to connect the test excel spreadsheet to Power BI I received the same "We're unable to connect. Please delete your credentials and try again later" notification. Am I missing something?
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!
- Same issue for me. Any news?
