Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I have an API :
curl --location --request GET 'https://api.typeform.com/forms/ecTbgcrP/responses' \
--header 'Authorization: tfp_KNzKHoGB1jDiiiTsttoNLF7Jf2MdYa4SWfuQexGJvX7_e4s2bwBcZnE4'
Now i want to read this API with this authorization in power bi query.
I tried the following but its not working unfortunately;
let
Source = Json.Document(Web.Contents("https://api.typeform.com/forms/ecTbgcrP/responses", [Headers = [Authorization = "tfp_KNzKHoGB1jDiiiTsttoNLF7Jf2MdYa4SWfuQexGJvX7_e4s2bwBcZnE4"]]
))
in
Source
How can i fix this?
Check the API documentation again. Authorization should say something like Basic or Bearer etc.
@lbendlin It's a Oauth2.0 authorization. So I have a token. How do i need to implement this?
Use "Bearer " (with space) and your token.
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |