How to access data using API in Power BI?

[Analitika]

Hi,

I would like to ask how I could access data using API in Power BI? I have this  API as example:

API: https://api.orderhive.com/setup/warehouse.

AccessKey: "asdaddg"

SecretKey: "sadsad"

Session Token: "sadasdsadsa"

tenant_id:"sadsad"

user_id:"dsadaS"

I press get data, web option. What next?

[Analitika]

Hi,

I would like to ask how to get data from API which is authenticated AWS Signature in Power BI?

[Anonymous]

Hi @Analitika ,

You can refer the following links to connect API in Power BI Desktop by web connector:

Chris Webb's BI Blog: Working with Web Services in Power Query

Web.Contents(
  "https://www.regonline.com/api/default.asmx/GetEvents",
  [
   Query=[ #"filter"="", #"orderBy"=""],
   Headers=[#"APIToken" = "insertAPITokenHere"]
  ])

Read API Data with Power BI using Power Query (mssqltips.com)

Connect to API

Calling REST APIs and Parsing JSON made simple with Power BI

Get Data from Twitter API with Power Query

Best Regards

[Analitika]

Problem is that I am using AWS authentification.