Hi Guy,

Welcome to our forum!

I haven't seen that error before, but this post has some ideas and resources, including a video from Microsoft, which I think will hope. 

Mynda

Hey Mynda and other readers off course 😉

Thanks for your swift response.

I think it's all a bit too complicated.
I was under the impression that there was a possibility to link this 'get-request'  through simple 'get data from web' (Power BI)

And add the specifications of the url for the get-request and the headers for api_key/user_name/password...
see attached png

When I try this in Power Query, I get another error code. (Translated it sounds like: Unable to connect - Found extra characters at the end of the JSON-input)

Looking forward to your insights, it's driving me crazy.

Guy

Hi Guy,

There's no image attached.

Have you read these blog posts :

Getting Started with API's in Power Query

Connecting to an OAuth API

You can most certainly connect to an API with Power Query/Power BI, but exactly how you connect to the API depends on the API itself. 

There are several ways to provide authentication like a username and password.  This is all dependent on the API, and I don't know which API it is you are trying to connect to, can you link to the API web site or documentation?

The error you are getting means that the web request isn't returning JSON, this will be because your authentication isn't working.

Regards

Phil

Case closed !

I've found the culprit: I used the wrong delimiter in my request, had to use "&". Simple as that
Thanks for your time.