cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Missing Authorization in connection string

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

3 REPLIES 3
Super User III
Super User III

Hi @Anderssons 

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.

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 🙂 

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.