Forum Discussion

jasonfordx's avatar
jasonfordx
Helper II
8 years ago
Solved

Connect API with Header ApiKeyName not going through

Dear community,   Im trying to connect my Excel/PowerBI and is not working. I read the entire forum and I could not reach the right answer for it.   My provider gave me the following instructions...
Need Help
  • Michal_cwiok's avatar
    Michal_cwiok
    8 years ago

    Perhaps this might work too:

     

Michal_cwiok's avatar
Michal_cwiok
Resolver II
8 years ago

jasonfordxThis is great! Thank you clarifying that it is case sensitive!

 

Would it be possible for you to paste the M/Power Query code from advanced editor? This would be helpful for solving future problems. Thanks!

jasonfordx's avatar
jasonfordx
Helper II
8 years ago

Yes, off course. It is working like this:

 

let
    Source = Json.Document(Web.Contents("URL", [Headers=[#"x-api-key"="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]])),
    #"Converted to Table" = Record.ToTable(Source)
in
    #"Converted to Table"

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Very Niiice jasonfordx !!

     

    But I have a question, you posted in the workspace and managed to put automatic update???

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    I know it's been a while since this was posted, but I'm struggling with the same issue. It might even be the same URL and the same API too (Breathe HR by any chance?).
    I tried both of solutions suggested by Marcin as well as jasonfordx's syntax. Sadly I get this error?

     What were the permissions settings? I used Annonumous and public.