Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Web API Key Authentication

Hello, I am trying to connect to a Web API in Power BI Desktop. The request requires token authentication with an "api_key" parameter.  I continue to get the error that an API key name must be speci...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi-  I have tried that, I have started a blank query and input Web.Contents("my api URL", [ApiKeyName="api_key"]) and saved it, and tried to Get Data from Web using the same api URL and selecting Web API inputting my key in the box. 

 

I still get the warning that I need to specify an API key name. Could it be that it is not specified in the right editor? Is there any where else to pass this auth?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I tried the auth trick by putting the api_key in the URL as a parameter and selecting Anonymous, that did not work. I received the error that I have invalid credentials but when I test my call in Postman with the same api key, it is fine.

       

      This is the query I have currently: which is still giving me the error that I have invalid credentials.

       

      • MartySchlafer's avatar
        MartySchlafer
        Regular Visitor
        1 year ago

        Three years late, but for posterity and accuracy... the code above is actually two PQ applied steps returning the first step.  The second step is named ApiKeyName with literal text value "api_key".  This should have placed inside the 2nd parameter as a field of a record.  Hence...

        Web.Contents("https://.......", [ApiKeyName="api_key"])