HiBob to PowerBI API Connection via Web

[MissBI_21]

Hi,

I'm trying to connect to HiBob's Post API by using PowerBI.

I have the following post curl request from HiBob:

curl --request POST \
--url https://api.hibob.com/v1/people/search \
--header 'accept: application/json' \
--header 'authorization: Basic XXXXX' \
--header 'content-type: application/json' \
--data '
{
"fields": [
"root.id",
"root.firstName",
"root.surname",
"root.email",
"work.site",
"work.department",
"work.manager"
],
"showInactive": true,
"humanReadable": "string"
}
'
I added the above to PowerBI by following the below steps:
Select "Get Data", "Web", and then select "Advanced". I then added the curl request as below:

However, when I click "OK", I get the below error:

Can anyone help by telling me what I'm doing wrong please?

[Anonymous]

Hi @MissBI_21 ,

I think you can go to Transform data -> Data source credentials -> Clear permission.

Then you can try again and Check if it is working.Also you can look at this topic, maybe it will help you: Solved: How to connect API to power-bi, can any one sugge... - Microsoft Fabric Community

Best Regards

Yilong Zhou

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

[MissBI_21]

Hi Yilong,

Thank you for your response. I tried this and it didn't work.

[macBJvR]

Hi MissBI_21

Have you had any luck with your request? HiBoB to PowerBI API Connection?

Regards