Forum Discussion
How to connect API to power-bi, can any one suggest me sample API to connect with power-bi.
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
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 RegardsLucien
5 Replies
- amitchandak
Super User
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 - Greg_Deckler
Community Champion
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.
- v-luwang-msft
Community Support
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 RegardsLucien
- BIBB
Advocate I
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.
