topic Re: How to access data using API in Power BI? in Developer

How to access data using API in Power BI?

Analitika — Wed, 19 Apr 2023 06:12:18 GMT

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?

Connect to REST API Power BI

Analitika — Wed, 19 Apr 2023 10:04:25 GMT

Hi,

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

Re: How to access data using API in Power BI?

Anonymous — Fri, 21 Apr 2023 01:55:15 GMT

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

Re: How to access data using API in Power BI?

Analitika — Fri, 21 Apr 2023 05:19:08 GMT

Problem is that I am using AWS authentification.