Connecting to API data source

[c-ssrinivasan]

hello Team,

I'm trying to connect to API from Powerbi. i'm landing into the screen as mentioned below url. can someone help ?

https://stackoverflow.com/questions/46968401/pull-data-from-a-rest-api-which-has-authentication-from...

[v-yuezhe-msft]

@c-ssrinivasan,

What kind of API do you connect to in Power BI Desktop? What authentication does the API support? There is a blog about how to connect to API in Power BI Desktop for your reference.

https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

Regards,
Lydia

[c-ssrinivasan]

Can we connect to REST API using direct query of powerbi.....

[v-yuezhe-msft]

@c-ssrinivasan,

It is possible, please take a look at the following blog.

https://www.progress.com/tutorials/odbc/directquery-your-custom-rest-api-in-power-bi

Regards,
Lydia

[c-ssrinivasan]

Hello ,

Thanks. here the main problem is passing slicer values to APi and retrieving the o/p. Can this be possible

[v-yuezhe-msft]

@c-ssrinivasan,

Could you please elaborate about "passing slicer values to API"?

Regards,
Lydia

[c-ssrinivasan]

yes we need to pass Slicer Values to API.

[v-yuezhe-msft]

@c-ssrinivasan,

I am not clear about your expected result, if you want to pass the slicer value of Power BI Desktop to your API source, I am afraid it is not possible.

Regards,
Lydia

[c-ssrinivasan]

yes...