How to use an API key to get data?

[Ronniemaccagee]

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?

[amitchandak]

@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/

[mahoneypat]

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

[camargos88 · Accepted solution]

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