Forum Discussion

StillLearning1's avatar
StillLearning1
Frequent Visitor
3 years ago

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 web API key name is provided". 

 

I do have a token with a key, secret, and authorization, but not of those codes work (I'm not too familiar with APIs). Can anyone assist with this error?

 

 

My process is:

  1. 1. Get Data from web.
  2. Enter the API call as the URL (https://rsu.bridgeapp.com/api/author/users) the same one that works in Postman
  3. Then I'm stuck at the authentication screen

  4.  

Need Help
Tutorial Requests

1 Reply

  • Bifinity_75's avatar
    Bifinity_75
    Solution Sage
    3 years ago

    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

     

     

Related content