Forum Discussion

DarylCox's avatar
DarylCox
New Member
4 years ago
Solved

Connecting to API help

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

Need Help

3 Replies

    • DarylCox's avatar
      DarylCox
      New Member
      4 years ago

      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

  • DarylCox's avatar
    DarylCox
    New Member
    4 years ago

    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