Hi Everyone.
I'm creating a custom connector for Power BI using Power Query/M Language on Visual Studio. In the final step of my connector, it will use Web.Contents() to retrieve a presigned file in Amazon S3.
Since it's a presigned file, my request CAN NOT have a Authorization Header, otherwise it will return an error. The problem is that I'm not able to make the following call without Authorization header:
results = Web.Contents(file_download_url)
I know that the function Web.Contents() have a Authorization parameter, so I could use something like:
results = Web.Contents(file_download_url, [Headers = [Authorization = "ANYTHING HERE"]])
However, I can't pass an empty Authorization parameter. If I use the default value, it will send a Basic Authorization, which will not work, due the presigned file won't return with an Authorization header.
One interesting thing to notice is that, if I copy the file URL and paste into Power BI, it works, because Power BI don't send Authorization header on the request (I've double checked it using Fiddler).
Does anybody know how to send a request without Authorization header?