Connecting to an Excel in https://wcs.bsnconnect.com/sites/

Hi,

If you can open that file via web browser it doesn't mean you can open it as easily using PowerQuery as the browser additionally runs the javascript that might have redirects etc.

Postman or curl or the snippet below should reveal the actual server response - which you mention it's a HTML - and starting from that HTML response we'll see where to go next and if it's easy.

let
 serverResponseAsText = 
    Text.FromBinary( 
        Web.Contents(
            "put-web-address-here" 
        )
    )
in
    serverResponseAsText

IF you decide to paste the serverResponseAsText here, PLEASE remove confidential information.