Forum Discussion

Sebastian_B's avatar
Sebastian_B
Frequent Visitor
3 years ago
Solved

Issues refreshing report in Power BI Service with Smart Recruiters API data source

Hi,

 

I'm using Smart Recruiters REST API with the following URL and Headers, to connect to some .csv reports

 

URL: https://api.smartrecruiters.com/reporting-api/v201804/reports/<reportID>/files/recent/data

HeaderValue
Accepttext/csv
X-SmartToken<your API key>

 

I configured the connection to each report in Power BI Desktop like this:

 

And it works flawlessly 

 

 

I created a report with several visualizations. I refresh data in Power BI Desktop and it gets the most recent reports from the Smart Recruiters API without issues.

 

I published the report on Power BI Service and it also works fine.

 

But I haven´t been able to set up the Scheduled Refresh of the dataset in Power BI Service and it seems to be related to the data source credentials.

 

 

I tried to use the different Authentication Methods, but always get the same error.

 

Also, I spoke to Smart Recruiters support, and they checked internally and said that the issue seems to be on the Power BI side. 

 

It's quite strange that every time I refresh data using Power BI Desktop it works, but it doesn't on the Power BI Service.

 

Any ideas to solve this issue are appreciated!

 

Sebastian.

Need Help
  • Sebastian_B's avatar
    Sebastian_B
    3 years ago

    I solved this issue by checking the "Skip test connection" in each one of the connectors created to ingest the reports from Smart Recruiters API.


    I still get the warning "Some credentials aren't validated as the...", but the dataset is refreshing properly in the Power BI Service.

     

    Sebastián.

5 Replies

  • Sebastian_B's avatar
    Sebastian_B
    Frequent Visitor
    3 years ago

    I solved this issue by checking the "Skip test connection" in each one of the connectors created to ingest the reports from Smart Recruiters API.


    I still get the warning "Some credentials aren't validated as the...", but the dataset is refreshing properly in the Power BI Service.

     

    Sebastián.

  • NewUser321's avatar
    NewUser321
    Regular Visitor
    2 years ago

    Hi, 

    May I ask where or how you find your reportID?
    I'm trying to connect to SmartRecruiters as well, but I just can't seem to make it work.

     

    Thank!

      • NewUser321's avatar
        NewUser321
        Regular Visitor
        2 years ago

        Thank you so much for your reply! 

        I tried doing the same as you did to connect to SmartRecruiters from Power BI,
        but for some reason it just doesn't want to work.

        I get the following error " The 'X-SmartToken' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer"

        Am I doing something wrong here?