Forum Discussion

cmfisher82's avatar
cmfisher82
New Member
10 years ago

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.

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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's avatar
    mack0352
    Frequent Visitor
    9 years ago

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

  • aogata's avatar
    aogata
    Frequent Visitor
    8 years ago

    I have the same issue.

    Was this authentication issue ever resolved?

  • yuusaneemu's avatar
    yuusaneemu
    New Member
    8 years ago

    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.