Calling API Based On Existing Column

[yigitersann]

Hi everyone.

First of all I am new to PBI.

I have an API => http://universities.hipolabs.com/search

I can get this table and the necessary datas from "basic connection" to web and then I can filter them out the way I want by using PBI filtered rows manually.

But I don't want to do this manually.

But what I want to learn is,

I want to call the API based on country column by sending query parameters.

For example =>;

6 different queries for 6 different countries

I searched a lot if there is an existing thread/topic about that and found 1-2 but unfortunately could not figure it out for myself. (Maybe mine is a little different)

So this is the whole table below from the link above except column names (I edited them)

Lots of United States, don't think it's filtered for US already 🙂

I want to filter the table based on county names.

So the table should look like below at the end for India for example; (for 1 query)

Would be glad if someone can help me about calling the API based on different country names

Thanks in advance

[v-mengzhu-msft · Accepted solution]

Hi @yigitersann ,

This post has similar problems to yours and may be helpful to you:

Solved: Calling multiple APIs based on a column - Microsoft Power BI Community

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly