Forum Discussion

jprice0401's avatar
jprice0401
New Member
6 years ago

How to bring data from a Rest API into Powebi including authentication Token

Hi there,   I am wondering if someone can help me connect PowerBI to the following REST API.   Directions on how to connect to the API are in the following link: https://dev.praemium.com/   How...
Data Protection
rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

Hello jprice0401,

 

Please try following:

 

let
      Source = Web.Contents("http://{URL as provided}/Portfolios HTTP/1.1", 
                            [Headers=[#"content-type"="application/json",#"x-pps-token"="YOUR-TOKEN-GOES-HERE",#"x-pps-api-version"="THE-API-VERSION"]]),
     JsonProductResponse = Json.Document(Source ,1252)
  in
     JsonProductResponse

 

Hope this helps.

jprice0401's avatar
jprice0401
New Member
6 years ago

Hi there thank you for your help.

 

I am still unsure where the body of the call would go in this solution i.e. the Portfolio ID and Username as in the link provided.

 

Thanks