Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
143
Views
Topic starter
I'm using Excel 2019 and I need to query one of our intranet sites using the URL, this is https.
Using the basic authentication method gives an error.
What solution for this?
Thanks
Posted : 24/11/2021 10:00 pm
Hi,
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.
Regards
Phil
Posted : 24/11/2021 11:50 pm
