cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StephenF Member
Member

API Credentials reset in Desktop to anonymous

I load my PBIX

 

I Click refresh

 

I get the an error and end up here

at1.png

 

 

 

 

 

 

 

 

 

 

 

In data source settings I notice the credentials have been set to "Not specified".

 

This is despite previously setting them to Basic with the proper username and password.

 

This issue constantly recurs with me having to change from anonymous to Basic and add the login informaiton for my API call.

 

Other times I get a wrong password error as it seems to have something in the password field thats incorrect - very strange behaviour.

5 REPLIES 5
Community Support Team
Community Support Team

Re: API Credentials reset in Desktop to anonymous

Hi @StephenF,

 

Could you please clear the permissions and try again?

 

2.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
StephenF Member
Member

Re: API Credentials reset in Desktop to anonymous

Hi Frank,

 

That doesnt affect the result.

 

What I did do was save the pbix under a different name. Ran the refresh in that and presto - no problems. I ran it again just to be sure and there was no issue

 

Then when I renamed this pbix to the original name, the Issue reccurred, checking the settings the permissions were set back to "Not Specified" once again. I set the basic username and password here and returned to the main screen and clicked refresh where I got 1 popup prompting me for credentials with the password chevrons having the wrong length and after filling that in correctly another popup for another api call that showed no username or password and the screen trying to get anonymous data.

Once it all completes refreshing through the several tables it updates I check the permissions again and they are once again set back to "Not Specified". I fill in the details again. Close permissions and click refresh and it shows this:

 

 

The password blackblobs should be 10 not 7

 

credentials.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I'm using the November release, and using 9 different API strings on this one website if its any use.

StephenF Member
Member

Re: API Credentials reset in Desktop to anonymous

Is there any other way to get support for this issue?

Highlighted
StephenF Member
Member

Basic Authentication Credentials do not save

 

I suspect this is a bug.

 

Basically my API credentials keeping getting reset to anonymous when I am doing a manual refresh on my 10 or so API calls.

 

I usually get asked for new credentials twice when I run the refresh of the 10 calls. They all are accessing the same API.

 

Thread here:

 

https://community.powerbi.com/t5/Desktop/API-Credentials-reset-in-Desktop-to-anonymous/m-p/615654#M2...

StephenF Member
Member

Re: Basic Authentication Credentials do not save

Disabling parralel loading for tables in settings fixes this issue.

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,482 guests
Please welcome our newest community members: