November 24, 2021
October 5, 2010
Need a lot more info to help you.
What error are you getting? Can you provide a screenshot?
Why are you using Basic Auth? Does your intranet site require it? Do you need to login to the intranet? If so, is it via a form on a webpage? If that's the case, Power Query can't do it.
If your intranet requires login/authentication it must allow it via a HTTP/API mechanism supported by PQ.
If the error is to do with security/SSL/HTTPS, I'd need to see the error. It could be that your intranet site's SSL certificate is invalid.