Hello,
Using Postman, I have this request (converted to C#) that I want to use in Power BI :
var client = new RestClient("https://myurl/docs/594354384545845");
client.Timeout = -1;
var request = new RestRequest(Method.GET);
request.AddHeader("profile", "full-access");
request.AddHeader("enduser", "enduser");
request.AddHeader("Authorization", "Bearer XYXYXYXYXYXXYXYXYXYYXYXXYYXYX");
request.AddHeader("Cookie", "KDFHGJDISJDFDUKDFGJDFHDFO");
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);
I make this in Power BI, that works just fine :
= Json.Document(Web.Contents("https://myurl/docs/594354384545845", [Headers=[Authorization="Bearer "&GetToken(), #"profile"="full-access", #"enduser"="enduser"]]))
GetToken() is defined like this :
= ()=>
let
url = "https://myurl/token",
headers = [#"Content-Type" = "application/x-www-form-urlencoded", #"Authorization" = "Basic XYXYXYXYXYXXYXYXYXYYXYXXYYXYX"],
postData = Text.ToBinary("grant_type=client_credentials&scope=business"),
response = Web.Contents(url, [Headers = headers, Content = postData]),
Data = Json.Document(response),
access_token=Data[access_token]
in
access_token
But when I try to add another very similar request like this from csharp in Postman :
var client = new RestClient("https://myurl/docs");
client.Timeout = -1;
var request = new RestRequest(Method.GET);
request.AddHeader("profile", "full-access");
request.AddHeader("enduser", "enduser");
request.AddHeader("Authorization", "Bearer XYXYXYXYXYXYXYYXYXYXYXYX");
request.AddHeader("Cookie", "DSHGDUTSDFHFDGKDG");
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);
I make this in Power BI :
= Json.Document(Web.Contents("https://myurl/docs", [Headers=[Authorization="Bearer "&GetToken(), #"profile"="full-access", #"enduser"="enduser"]]))
But for an unknown reaser, I get the following error :
Expression.Error: The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer
To be noted that if I reverse the order of the headers, then, in the error message, instead of "The 'Authorization' header", I get "The 'profile' header" or "The 'enduser' header", the message takes all the time the first header that I've set.
Do you have any idea what the issue can be please ? In Postman, it is the same code (and both requests are working), but when I use the same code in Power BI, it doesn't work...
