I have been using the personal gateway to connect to our SQL server for our Power BI reports on the Web Service for a few months with no problem. As of yesterday, I get the following error when I try to refresh any of our reports: "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."
When I try to sign in with my credentials, it hangs and the dots spin after I click Sign In. It does not give an error even if I try to sign in with intentionally wrong credentials it just stays hangs indefinitely. So far, I have tried reinstalling Power BI desktop and the personal gateway, different authentication methods, deleting and reuploading the reports, and different browsers. Any help would be appreciated.
try set blank privacy level.
for ms sql it work
Thanks for the insight, that seemed to do the trick. I deleted all of our reports off the web service and then reuploaded them and was able to sign in with the privacy level blank. It'd be nice to know what is causing the issue though since its a huge hassle to need to delete and reupload if this happends again.