Hi! I want to connect my power bi to data source from sharepoint folder. But when i sign in with my microsoft account, i got the error message : "We're unable to connect. Please delete your credentials and sign in again later". Does anyone know what happened here?
*note: my power BI desktop version is january 2022
I have the May 2022 version of PBI desktop. I wanted to connect PBI to an Excel spreadsheet on Sharepoint but was unable to get it to work. I tried 2 different connectors and every permutation I could find and nothing worked. I used at least 5 examples from online, many of them very old, and my own permutations. I tried connecting to a Sharepoint folder and to the file, and there were several ways to get a link to the file or folder which PBI needed. Nothing worked.
I believe I submitted this as an Idea to have the ability to connect to a Sharepoint folder or file.
Our workaround will be to host the file on a network drive backed up by Onedrive to the cloud. We have not set this up yet so I haven't tested it.
I faced with this issue once when I changed my password and I was not able to refresh the report that was connected to the sharepoit.
I did all and at the end that issue was solved by installing the PBI desktop again!!
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
I also have re-installed my PBI Desktop but still get the same error. On the other hand, I also asked my friend who has never connected to sharepoint, and strangely he got the same error.
What authentication method are you using?
You could try this:
Power BI Desktop customers may experience authentication issues attempting to connect to data source using AAD and may see the following error message "We're unable to connect. Please delete your credentials and try again later". As a workaround customers can go to Power BI Desktop and enable Options -> Security -> Authentication Browser -> “Use my default web browser”.
Used the microsoft account authentication method.
Options -> Security -> Authentication Browser -> “Use my default web browser”
is not available in my power bi dekstop version (january 2022)
You can edit/clear your credentials by going file-options and settings-data source settings:
Then seleting the datasource and clearing the permissions
Hi thank you for replying.
I did what you said to clear the permission, but it still not working. I also tried to create a new pbix file and make a new connection to sharepoint but get the same error message
Yes I got it to work.
First, upgrade your PBI Desktop version, it's free. These instructions are for PBI Desktop, not for PBI Paginated Reports or any other PBI component.
Now go to PBI Desktop.
I hope this helps!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.