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.
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.