Connecting to API help

[DarylCox]

Good morning everyone.

new user of Power BI here.

I have started a new job and am looking to connect to their full suite of API's so i can create some dashboards.

i can access the API's already using Postman but am struggling on what i need to do within Power BI to get the data.

Essentially there is an identity server where i first have to get a bearer token in order to access the API

i have tried using the Web method for get data and adding the URL but it errors with authorisation

i have looked at using the advanced editor when using the blank query but again unsure how to add the access credentials in

can anyone offer some wisdom

thanks

Daryl

[DarylCox]

So cant seem to get the second part working to automatically refresh the token each time.

i have followed the steps in the link but i get an error.

this is the query

but this is the response i get

i know the URL is correct as it works in Postman and i get a valid token.

could it be to do with these elements i have set in Postman

@amitchandak 

[amitchandak · Accepted solution]

@DarylCox , refer if this can help

https://www.advaiya.com/generate-dynamic-token-and-get-data-from-custom-api-in-power-bi/

[DarylCox]

Many thanks for this.

managed to connect to the API, just struggling with the final part to automatically refresh the token each time.

i am suspecting it is because i have another parameter of tenant to include so will keep trying