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

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

chris05 — Tue, 28 Nov 2023 19:16:51 GMT

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 the googel (use Basic, Advance - with/without Authorization in the header, add api key to username)

The API URL with the Bearer token works fine in Postman, so I'm really not sure why it is not connecting in Power BI.

Can someone help me please. 😢

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

Anonymous — Thu, 30 Nov 2023 07:15:47 GMT

HI @chris05,

Perhaps you can take a look at the following blog about use web connector with optional parameters usages if it help for your scenario:

Using The RelativePath And Query Options With Web.Contents() In Power Bi

Regards,

Xiaoxin Sheng

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

Karltomm — Fri, 01 Dec 2023 08:35:58 GMT

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.

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

chris05 — Mon, 04 Dec 2023 19:18:22 GMT

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 :

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

chris05 — Mon, 04 Dec 2023 19:19:26 GMT

Hi @Anonymous ,

I'll be checking this! Thank you!

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

Karltomm — Tue, 05 Dec 2023 07:28:45 GMT

Here is an example code I made for one API, the challenge I think is to understand what the API wants in the Headers and Body information.

This is first step to get the Token, then you will need to use the token in a second call to the API where you GET the data you want.

let
urlLogin="???",

//Body information with credential in this case
body = "{
""License"": ""??"",
""UserName"": ""??"",
""Password"": ""??"",
}",

//Create a JSON request to past to API
Parsed_JSON = Json.Document(body),
BuildQueryString = Uri.BuildQueryString(Parsed_JSON),

//Send and recive a replay inclusive the Access token.
GetTokenRecord = Json.Document(Web.Contents(urlLogin,[Headers = [#"Content-Type"="application/json",#"Accept"= "application/json"], Content = Text.ToBinary(BuildQueryString)])),

// Pick the token from the record, in this case the record was called Token in the table from the API.
token = GetTokenRecord[Token],

// Create the access token with Bearer in front if needed
access_token = "Bearer "&token,

in
access_token