Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Proud to be a Super User!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |