Forum Discussion
Pulling data from API - "A web API key can only be specified when a web API key name is provided"
HI, I'm trying to use an API to pull data into Power BI. I tested the call in Postman and it works, but in Power BI I can't even authenticate it. I get "A web API key can only be specified when a...
Hi StillLearning1 , how did you enter the token in the query?.
I leave you an example of how APIS queries are made with headers and body:
= let
url = "http://..........",
body = "{""date_from"": ""2020-07-05"",""date_to"": ""2025-12-31"",
""utility_ids"": [""61978731d6188e1511a401cd""]}",
Source = Json.Document(Web.Contents(url,[
Headers = [#"Content-Type"="application/json", Authorization ="Token ........................"],
Content = Text.ToBinary(body)
]
))
in
Source
And check in Power bi desktop, in options, the data source configuration (edit permissions), is correct:
Best regards