Forum Discussion

ibutur's avatar
ibutur
Frequent Visitor
9 years ago

A web API key can only be specified when a web API key name is provided.

Hi guys,   I'm trying to connect to a database on Klipfolio. I'm using my ID as explained here: https://klipfolio-api-reference-guide.readme.io/docs/data-source-instances-data so, it's https://ap...
nnosaj's avatar
nnosaj
Frequent Visitor
7 years ago

This might look like a silly question for you, but how did you actually enter the API key and Value as a header?

 

I have this API from an Azure app service secured by Azure Active Directory, and I generated a key (client secret) from there.  I am struggling to put that key into the request header when creating a Power BI report (Get Data from Web).  I cannot find the API key name.  I mean I got the actual API key but i do not have the API key name or can't seem to find it. 

ericOnline's avatar
ericOnline
Post Patron
7 years ago

Hi nnosaj. I'm fairly new at API calls and its been awhile since I worked on this project. I ended up writing a POST request in the Advanced Editor. Check this forum discussion between ImkeF and myself. Might have some insights. 

Good luck!

  • nnosaj's avatar
    nnosaj
    Frequent Visitor
    7 years ago

    Thank you, ericOnline! Yes, I might have to try the Advanced Editor.   I find the UI is not as simple to use as it looks, when it comes to particular cases like this.

    • nnosaj's avatar
      nnosaj
      Frequent Visitor
      7 years ago

      Silly me, actually ericOnline's solution above worked for me as well.  It seems there is currently no direct way to use Azure AD as authentication via the UI.  I opted to use API key authentication, but did it the wrong way.  So i modified my api to have a custom request header passing the API key, and applied the steps above in my Power BI report.