Connect to Web API with custom header

[DanT1994]

Hi,

I'm getting the following error when trying to connect a web API.

Using an online API testing tool, my URL and custom header looks like this:

So, I'm maybe simplifying this too much, but in PowerBI i'm entering it like this:

And it's throwing up the following error:

How can I get around this?

Thanks in advance
Dan

[Anonymous · Accepted solution]

HI @DanT1994,

Perhaps you can try opt use following code to use web connector getting data with apikey in anonymous mode:

let
    url="xxx.xxxxxx.com",
    apiKey = "key",
    headers = [

        #"CLICDATA-API-KEY" = apiKey,
        #"Content-Type" = "application/json"
    ],
    path="/api/xxx/xxx",
    request = Web.Contents(url, [ Headers = headers, RelativePath= path])
in
    request

Using The RelativePath And Query Options With Web contents 

Regards,

Xiaoxin Sheng

[lbendlin]

yes, you have to cancel out of that dialog first.

[DanT1994]

Unfortunately if I do that, the data source wont be there so the 'edit permissions'/'clear permissions' boxes are greyed out.  There's no way of clearing the permissions at the same time as adding the data source...

[lbendlin]

Now would be as good as any time to start over, with a new PBIX file...

[lbendlin]

As it says in the error message - you need to include the authentication either in the header or in the body.

[DanT1994]

Thanks for the reply, please could you expand/advise how I'd do that?  I thought I had included my authentication key in the header (screenshot in original post).

Thanks

[lbendlin]

Go to Data Source settings, clear permissions for the API URL, and on next try use anonymous auth.

[DanT1994]

It won't allow me to save the source, because of the above error, so I'm unable to go into data source settings and clear permissions...

Thanks
Dan