Forum Discussion

Frequent Visitor

6 years ago

Solved

How to use an API key to get data?

Hi I have a GPS company API and wanting to connect to data through an API, how would I start this?

The get data through web doesnt seem to be working?

Tips and Tricks

Tutorial Requests

camargos88
6 years ago
Hi Ronniemaccagee ,

You can follow this post, I believe it has your answer:
https://community.powerbi.com/t5/Service/Connect-to-API/td-p/810287

3 Replies

camargos88
Community Champion
6 years ago
Hi Ronniemaccagee ,

You can follow this post, I believe it has your answer:
https://community.powerbi.com/t5/Service/Connect-to-API/td-p/810287
mahoneypat
Microsoft Employee
6 years ago
Please see this post or the others out there to get started with calling an API from the query editor in Power BI.

https://www.mssqltips.com/sqlservertip/6318/read-api-data-with-power-bi-using-power-query/

If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
amitchandak
Super User
6 years ago
Ronniemaccagee , refer for 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/