cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tallyski
Frequent Visitor

We're unable to connect. please delete your credentials and try again later

I did look at the suggested forums, but nothing helps solve my issue.

I am working on a report that I update daily, but yesterday it sprung a surprise. I refresh it manually, but yesterday it did this:

Tallyski_1-1654181003114.png

 

I am logged in to Power Bi with my company Pro account. I have been searching for an answer, but in everything I try, I have had no joy. Further information:

Tallyski_2-1654181057651.png

This isn't the only file having the program. If the report retrieves data from a file on the web it does this. I have files that retrieve data from my computer, and they refresh no problem.

 

Thanks in advance.

1 ACCEPTED SOLUTION

John, thank you. I had our IT look at it, and they said it was something to do with credentials. They were able to fix it by clearing caching and changing my password. I have had a new issue pop up after being able to refresh. Should I share that here or start a new thread?

 

I'll share your comments with our IT team.

View solution in original post

21 REPLIES 21
G05DVD
New Member

Thank you so much for this. Have been tearing my hair out all morning!!

AStolk
Frequent Visitor

I met the same issue and solved it thanks to this article so many thanks!

Business Consultant PPM @ QS solutions
MCTS & MCP
Syndicate_Admin
Administrator
Administrator

Excellent thanks

QuestionMark7
Regular Visitor

Is there any workaround other than installing the new version? I'm using the report server and can't install any version newer than January 2022. 

In the meanwhile I've found a workaround for my case. The browser authentication option is not available in the menu in my version, but it still can be enforced by modyfing the Power BI settings file. If anyone has the same problem, I can post a more detailed solution.

Hi,
I am facing the same issue in Report Server, can you help me with the workaround, please?

Hi,

sure, I performed the following steps:

1) Navigate to your Power BI settings folder, the path should look like this:

 

C:\Users\[Your User Name]\AppData\Local\Microsoft\Power BI Desktop SSRS

 

2) Inside you will find the Users.zip. Please make a copy of it before proceeding further, just in case something goes wrong.

 

3) Open the zip archive - it contains several files and folders. Navigate to the UserInterface folder, which contains the Settings.xml file.

 

4) Open the Settings.xml file in a text editor such as Notepad. At the end of the file you should find a series of various Power BI settings, ended by the </Entries> entry. For better orientation you can also open the Settings.xml file in a web browser before editing it just to learn its structure. The section I'm referring to should look like this:

 

QuestionMark7_0-1661881081703.png

 

5) Now you need to add the following entry before the </Entries> line:

 

<Entry Type="UseSystemBrowserForAuthentication" Value="l1"/>

 

It's also visible on the screenshot above.

 

6) Save the changes made to the file and to the archive. Now Power BI should use web browser for authentication for sources such as SharePoint. Please note that the setting will still not be visible in the software's options menu, it's just enabled via the settings file.

 

I haven't noticed any side effects of such modification so far, but just in case you will have a copy of your previous settings. I hope that will work for you as well!

Thanks!!! It worked.

Anonymous
Not applicable

It has nothing to do with credentials. 

Go to files --> options --> security under globle --> scroll down to authenticator browser and tick use my default browser will solve your problem if your credentials are correct.

Worked for me, thanks!

Go to files --> options --> security under globle --> scroll down to authenticator browser and tick use my default browser will solve your problem if your credentials are correct. This worked for me!,

 

Kudos !

This worked for me!

JVP
Frequent Visitor

Thanks this did the trick. I think my organisation recently updated the browser so the settings must have resetted. 

Thanks this solved my issue also. 

This fixed it right away for me. Thanks!!

Ed-in-SD
Regular Visitor

JohnSchown
Advocate I
Advocate I

Looks like the following work-around was posted to the Support Status site:

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”. Engineers are investigating the issue and an update will be provided soon.

John, thank you. I had our IT look at it, and they said it was something to do with credentials. They were able to fix it by clearing caching and changing my password. I have had a new issue pop up after being able to refresh. Should I share that here or start a new thread?

 

I'll share your comments with our IT team.

hi, 

 

 I went through the Steps below to free up my account after changing AD Password.  issues were mostly with PowerBi connecting to Microsoft O365 SharePoint Shared Documents folder. 

 

Not sure which one really worked, with Microsoft it could have taken time to update, but my access to my data files was down for 2 days trying to reconnect. 

 

Background, using powerbi with our internal security there are only a few places we can save our data files, one is o365 SharePoint. 

 

AD required password change: 

 

Permissions deined trying to connect to \\business.o365.sharepoint.com@SSL\Sites\yoursite  

 

1. rundll32.exe keymgr.dll,KRShowKeyMgr   - Clear user/passwords

    Still not able to connect, same error

 

2. In powerbi, Settings, Data source Credentials

    still not authorized to connect to sharepoint files. 

 

3. onnect-pnponline -url https://Businesso365.sharepoint.com/sites/yoursite -UseWeblogin

    After which i was able to reconnect

 

hope this helps....

William

Hi, @Tallyski 

Glad to hear your original question was resolved.

If you have a new issue, it is recommended to open a new thread for a detailed explanation.

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors