How to connect API to power-bi, can any one suggest me sample API to connect with power-bi.

[Anonymous]

Hi Folks, 

I want to take data from API and want to load into Power-Bi.

Can any one suggest me how to do this and also, how can i get sample API for practice.

Regards,

Pratik

[BIBB]

The web.contents function is your key to start interacting with APIs in Power BI, in the link below you will find an article on how to start using this. 

Web.Contents and APIs in Power BI

Web.Contents in Power BI

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Test like the below:

Step 1:

Open the Power BI desktop. Click on the “Get Data” button and select the “Web” option as shown in the below screenshot.

Step 2:

Click on the “Connect” button. A new window will pop up and you will see two options. (Basic and Advanced)

Step 3:

You must enter the URL of API which returns the data you want to fetch. Fill in the URL and click on OK. 

Power BI will automatically arrange the results fetched by calling in a key-value pair in the form of rows. You can also use the advance option if you need.

And to learn more details ,refer:

Connect API Data in Power BI

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[andysherrill]

no help!!!   this does not work.

[Greg_Deckler]

@Anonymous So like a custom API? Sounds like you would be writing a custom connector at that point or using R or Python. Here's an example of essentially working with an API in R.

Visualizing and interacting with your Azure Machine Learning Studio experiments | Microsoft Power BI Blog | Microsoft Power BI

[amitchandak]

@Anonymous , Rest API ?
https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400
https://www.progress.com/tutorials/odbc/directquery-your-custom-rest-api-in-power-bi
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
https://www.youtube.com/watch?v=ipI6mrWLQKA