Missing Authorization in connection string

[Anonymous]

Hi! I have a report that retrieves data via an API. The code looks like this:

Source = Json.Document(Web.Contents("https://XXXX/api/external/statistics/v1?from_date=2020-09-01&to_date=2020-10-01&environment=live&language=sv-SE&key=conversation_count", [Headers=[Authorization="XXXXXX"]])),

This works fine, but when I upload the file to the Power BI report server, authorization is not included in the connection string. I get this error message: The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly. 

How should I do so that authorization is included in the connection string? I can not edit it in report server. I need to have autorization as a header, otherwise it wont work. 

Best regards, Sophia

[PhilipTreacy]

Hi @Anonymous 

What type of Auth is it? 

How does the Auth need to be provided? In encoded form like this?  

EncodedCredentials = "Basic " & Binary.ToText(Text.ToBinary(ClientID & ":" & Secret), BinaryEncoding.Base64),
    
    Token_Response  = Json.Document(Web.Contents(api_url,
    [ 
      Headers = [#"Content-Type"="application/x-www-form-urlencoded",#"Authorization"=EncodedCredentials],
      Content=Text.ToBinary("grant_type=client_credentials")
    ]
    )
    )

Or plain text?

data= Json.Document(Web.Contents(api_url,
   [ 
     Headers = [#"Authorization"="Bearer "&token,#"Content-Type"="application/json"]
   ]
   )
   )

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

Hi again! @PhilipTreacy 

I tried to create a new report that I retrieve data via the same api, but this time it says that there is no data source in the power bi report server.

Scheduled Data Refresh is not available for reports. The report does not have any external data connections defined or is using an unsupported data source. Learn more

In the report, there are data sources under "Global Permissions" but not "current file".

/Sophia 🙂 

[Anonymous]

Hi again, thank you! @PhilipTreacy 

Sorry but I do not know much about APIs, I just followed a guide. I have got one Bearer token. I have entered it like plain text and it works fine until i upload it on Report Server. When Power BI ask me to enter credentials, i choosed anonymous. How can it work locally on my computer but not on report server?

Regards Sophia