cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
moefinley Visitor
Visitor

REST API data source dynamically built from previous separate REST API data source

I'm trying to get data from TeamCity into Power BI. The data is for each build and I get the list of builds with a separate call.

 

http://teamcityserver/guestAuth/app/rest/builds

 

Which returns something like this:

 

| Attribute:href | build.Attribute:id | build.Attibute:buildTypeId | build.Attribute:number |

 

How can I then dynamically make more data sources by calling the API again with 

 

http://teamcityserver/guestAuth/app/rest/builds?buildTypeLocator=ExampleBuildTypeId

 

Where ExampleBuildTypeId would be taken from the previous call to the API.

 

Thanks for any help

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: REST API data source dynamically built from previous separate REST API data source

@moefinley,

You can add custom column in Power BI Desktop by calling function to return the result of all the calls. For more details, please review the following similar threads.

https://community.powerbi.com/t5/Desktop/Iterating-changing-query-parameter-to-build-a-merged-table/...
https://community.powerbi.com/t5/Desktop/Iterating-over-start-and-end-dates-for-multiple-API-calls/t...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.