How to Authenticate a REST API in Power BI?

[jwillis07]

Good evening all, I'm in need of some help and I hope I've come to the right place...

I've only ever worked with local files or open APIs however this time, I'm trying to access a REST API but I'm currently unable to get past the authentication.

The API URL is... https://psa.pulseway.com/api/servicedesk/tickets

The documentation for the API can be found at... https://psa.pulseway.com/api

Within the documentation it says that I need to include the following header parameters...

Accept = application/json

Content-Type = application/x-www-form--urlencoded

grant_type = password

username = Authenticated user username value (my Pulseway username)

password = Authenticated user password value (my Pulseway password)

tenant = Authenticated user company tenant value (my Pulseway company tenant name)

So, in Power BI Desktop, I'm following the below steps:

1. Get Data > Other > Web

2. Click advanced, and enter my API URL as whole, not in parts.

3. Add in the header parameters as above, when complete, it looks like the below:

*I've left my credentials blank for security purposes but I fill them in before moving to the next step 

4. Press OK

5. I then get a failure to authenticate message as below,

6. As I've already included my credentials in the headers, I believe I should now just click "Anonymous" and then "Connect" - Only this doesn't work and I get the same error message again...

I have no idea what I'm doing wrong and have gotten lost in documentation to just get this far, so if anyone can point me in the right direction it'd be hugely appreciated and you might just save my job!

Thank you in advance,

Jason

[kurrysamir]

Hi Guys,

Getting the same problem as the discussion, using a REST API with Authorisation set as Basic Auth having username/password and header including api-key, Did anyone find a solution for this? 

Thanks in advance. 

[Pree]

Did you solve the problem? I am getting the same error. I am looking for the soluction to this problem too. 

[v-henryk-mstf]

Hi @jwillis07 ,

If you want to Authenticate a REST API in Power BI. You should first need to clear the permission in the data source setting, the choose "Web API" instead of "Anonymous", then make a try.

Provide corresponding official documents for reference: Power Query Web connector | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BizviG]

Hi v-henryk-mstf!

I think what we are looking for is a way to pass the authentication in the header INSTEAD of the Web API Key
If indeed that would be the method for activating auth through the header parameters in the case described, what would one write in the KEY-field? Would that be whatever was returned with the Authorization: Basic?

[jwillis07]

If anyone even has any links to tutorials or anything, it would help more than you know.

I just can't get my head around this 😞