Forum Discussion
Power Query for files on https web site under basic authentication
Hi,
I'm having problems getting pass the basic authentication when trying to connect to server https://xxxx.xxx.hr/~xxxxxx/xxxxxx/. I'm trying to use power Query Web Content but when providing User and Password under Basic Authentication it doesn't work. I tested login, password in browser and they work fine. Does anyone has any experience with such task? Any help is more then welcome. *** One quick note: I can pull json file when I provide full link to json file using Get Web Content, and it doesn't ask me any permissions.
4 Replies
Not sure what kind of files those are, but you cannot connect to XLSX, CSV, or other files stored on a web server like that. The web connect is for reading HTML web pages, not files out of a directory. You have to have a specific connector to read files out of directory, like the connectors provided for SharePoint libraries, Azure DataLake, etc.
Hi Anonymous ,
See if it will help you.
https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/
Or you can try to clear credentials in datasource setting and access by anonymous.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
