Power Query for files on https web site under basic authentication

[Anonymous]

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.

[V-lianl-msft]

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.

[Anonymous · Accepted solution]

It got solved when I removed it and then re-added it as data source. After defining u/p and privacy it started working ok. I'll keep updated if errors happen. 

[edhans]

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.

[Anonymous]

HI, 

files are of .json type. What I want is to get list of files on server, and that is what I can't. Thanks for quick response.