Reply
drakko
Frequent Visitor
Partially syndicated - Outbound

PBI - SmartRecruiters connection - API

Hi All,

 

I'm trying to pull the data from an API offered by SmartRecruiters (SR).

Some datails on the service can be found here: https://dev.smartrecruiters.com/customer-api/live-docs/customer-api-2/#/

 

I continuously get an error saying: "A web API key can only be specified when a web API key name is povided".

I do have a key generated by SR admin - and he assured me there was no such a thing like key name.

webapi_failure.PNG

 

 

I'm missing sth here.

Any help appriciated!

 

Kind regards,

Chris.

 

3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Syndicated - Outbound

@drakko,

Please specify an API key name in the hearers area of
Web.Contents using Advanced Editor, then check if the error goes away.

There is also a similar thread for your reference.
http://community.powerbi.com/t5/Desktop/Connect-Power-BI-Desktop-to-insightly/td-p/209079

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicated - Outbound

Hi v-yuezhe-msft,

 

thank you for a tip.

I've experimented with it - I'm just missing something probably really obvious to you!

Attaching a screen - can you make another suggestion?

Any help much appriciated!

 

Chris.

 

WebAPI_connection_issue_v2.PNG

Syndicated - Outbound

@drakko,

Add a blank query in your PBIX file, directly write Power Query code in the Advanced Editor of the blank query as described in the following similar thread.

http://community.powerbi.com/t5/Desktop/Connect-Power-BI-Desktop-to-insightly/td-p/209079

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)