Forum Discussion
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...
Perhaps this might work too:
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"
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.