Share via

Excel - Odata Connection: "A web API key can only be specified when a web API key name is provided"

Anonymous
2022-09-01T15:34:09+00:00

Hi I'm trying to use an Odata feed to import data into Excel. The Odata feed requires an API Key to be associated. I set up the Odata feed, but when I insert my Web API key I get this message: "A web API key can only be specified when a web API key name is provided."

This I have learned from other help articles across the web that I am missing the API key from the header from my request.

Questions are: how do I put the API key into the header of my request? And what should that update look like? I see answers like "paste this code into the Power Query editor", but they don't say where to put this information and I am too basic in my Power Query knowledge to understand what I'm doing without step by step instructions. Please help!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-01T16:57:57+00:00

    Dear Kate,

    Good day! Thank you for posting in Microsoft Community.

    You may click on Data>Get Data>From Other Sources>Blank Query to insert the code to see the result.

    For your reference: Create, load, or edit a query in Excel (Power Query) (microsoft.com)

    Welcome to share any updates when you have time if you need further help on this issue.

    Sincerely,

    Cliff | Microsoft Community Moderator

    0 comments