Re: Connecting to API data source

c-ssrinivasan · ‎12-17-2018

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...

Anonymous · ‎12-18-2018

@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 · ‎12-25-2018

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

Anonymous · ‎12-26-2018

@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 · ‎12-26-2018

Hello ,

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

Anonymous · ‎12-31-2018

@c-ssrinivasan,

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

Regards,
Lydia

c-ssrinivasan · ‎12-31-2018

yes we need to pass Slicer Values to API.

Anonymous · ‎01-01-2019

@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