topic Re: Missing Authorization in connection string in Developer

Missing Authorization in connection string

Anonymous — Thu, 19 Nov 2020 10:25:28 GMT

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

Re: Missing Authorization in connection string

PhilipTreacy — Thu, 19 Nov 2020 13:18:03 GMT

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.

Re: Missing Authorization in connection string

Anonymous — Mon, 23 Nov 2020 15:56:08 GMT

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

Re: Missing Authorization in connection string

Anonymous — Mon, 23 Nov 2020 15:55:38 GMT

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 🙂