This is what I do:
Start blank query.
Use Advanced editor
Type in the below code:
let
Source =
Web.Page(Binary.Buffer(Web.Contents("http://www.commcarehq.org/a/crs-test/reports/configurable/597d08e87a076786e249d2168724aa6d/")))
in
Source
Then Under connection properties I set Basic authentication
Provide credentials provided.
Refresh data source.
It doesnt work. I get the authentication screen as data.
Help?