Forum Discussion

chris05's avatar
chris05
Frequent Visitor
2 years ago

Get data using web API to Power BI - Token Prefix Missing

Hi, I'm new to Power BI and I've been trying to connect data using API with Authentication in Get Data - WEB. I keep on getting "Token Prefix Missing" error. I've tried all the steps I saw from...
Need Help
Tutorial Requests
Karltomm's avatar
Karltomm
Regular Visitor
2 years ago

Hi!
Do you know what type of API you try to connect to?

I never get the Get Data - Web to work, in my case it has been REST-API with credentials and token authorization. If its the same case for you, you will have to start with a Get Data - Blank Query and then write code were you pass your credentials and token to the API. 

You also need the API documentation to be able to see how and where the token and credentials should be passed.

Hope it can help you on your path to find the solution.

 

  • chris05's avatar
    chris05
    Frequent Visitor
    2 years ago

    Hi Karl,
    Thank you for your reply!
    The API I'm trying to connect is from Ceipal (this is an applicant tracking system used for recruiting). The API documentation can be downloaded for each report that I will need from the site. I'm not really sure how to know the type of their API but as per their API documentation I have the below details

    API NAME :  

    Authentication Url :  
    Username :  
    Password :  
    Auth Key :  {api_key:}
    Format :  {json:1}  (0 for xml format)
    Generate authtoken using this authentication and use this auth token to get the access for below API.

    Authenticaiton type :  bearer token
    token :  Token generated from authentication
    Method :  GET
    Endpoint URL :