cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Daveed1973 Regular Visitor
Regular Visitor

How to connect to a service API to Power BI

I have been given API documentation to connect to one of the services we use with an API. I have managed to do this using the command prompt on Windows and CURL commands and can see the data that I need to.

 

To connect though I have to authenticate first and then use a token that lasts only an hour to query the data.

 

Ideally I need to be able to bring this data into Power BI so that we can present it, but have no idea how I could connect Power BI to the service using the same sort of CURL commands.

 

For example, this is the CURL command I am using to request the token,..

 

curl --request POST --url https://xxxxxxxx.xxxxxxxx --header "Content-Type: application/json" --header "Accept: */*" --data "{\"username\":\"xxxxxxxxxxxxxxx\",\"password\":\"xxxxxxxxxxxxxx\"}"

This then returns the token which I then add to the other CURL commands to interogate the data.

 

Are there any resources out there which will help me turn what I have above into something that allows Power BI to interogate the data?

 

Haven't a clue where to start, so any help would be greatly appreciated.

1 REPLY 1
BrianMiller Frequent Visitor
Frequent Visitor

Re: How to connect to a service API to Power BI

This may not be the most elegant solution but have you considered using the API to load the data into an intermediate source like a database table or spreadsheet and reading it into power bI from there?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors