cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DarylCox
New Member

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

1 ACCEPTED SOLUTION
3 REPLIES 3
DarylCox
New Member

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

DarylCox_0-1658486579695.png

but this is the response i get

DarylCox_1-1658486636101.png

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

DarylCox_2-1658486747165.png

@amitchandak 

amitchandak
Super User
Super User

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.