Forum Discussion

TuanPham1999's avatar
TuanPham1999
Frequent Visitor
7 years ago
Solved

Pull data from API using POST method in Power BI

Hi all, I'm a fresher in Power BI Desktop. my mission is extract data from given credentials include: ClientID, Password and Url. The credentials must be Base64 encoded for use in the POST /oauth2/to...
Need Help
Thiaan's avatar
Thiaan
Regular Visitor
3 months ago

if you add content ie:

 Content = Text.ToBinary(postData)

 to the web.conents on the call it automatically does a post. just send a parameter to the API ie: 

Content = Json.FromValue([ pageSize = "200" ]), //even though this MIGHT be the same as the default, specifying content forces the post. 

finally:

...
Web.Contents( Url

                              , [ Headers = Headers
                              , Content = Json.FromValue([ pageSize = "200" ]) // ← This makes it a POST
...