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

Web Based Data Extract - Resets to Anonymous Authentication

Hi All,

 

I'm using PowerBI Desktop to extract CSV data from a website that requires basic authentication.  Everything is working great in the PBI Desktop client.  I'm able to refresh the data without any issues.

 

However, once I publish the data to the PBI service, the authentication information changes itself from "Basic" to "Anonymous" for the data source.  Even after updating the credentials back to "Basic" and entering the correct login and password, the dataset changes itself back to "Anonymous" within a minute or so.  Obviously, this is problematic because I'm now unable to schedule a data refresh.

 

Has anyone else experienced this issue?  Does anyone know how to resolve and keep the correct basic authentication information?  Any assistance from the community would be greatly appreciated.

4 REPLIES 4
BLuGLo Visitor
Visitor

Re: Web Based Data Extract - Resets to Anonymous Authentication

I am having the exact same problem.

I can authenticate in PBI and in Excel via Power Query. 

 

Hopefully there is a resolution to come

mack0352 Frequent Visitor
Frequent Visitor

Re: Web Based Data Extract - Resets to Anonymous Authentication

I am having the exact same issue right now. Apparently this is still an issue? Did you ever figure out a workaround? 

aogata Frequent Visitor
Frequent Visitor

Re: Web Based Data Extract - Resets to Anonymous Authentication

I have the same issue.

Was this authentication issue ever resolved?

Highlighted
yuusaneemu Visitor
Visitor

Re: Web Based Data Extract - Resets to Anonymous Authentication

Same issue here.  I suspect the order of occurrence is the API call fails and returns a 40x response, then PowerBI treats the stored credentials as bad and resets the authentication method to anonymous.

 

It would be nice if PowerBI did try to be "smart" and reset the stored authentication method/credentials, then users can just try to refresh the data again later.