Examples of WebMethod.Post(...)

[mloxton]

Hi all,

I'm interested in updating data sources via a REST API based on information generated from a report, but I'm struggling to understand how to use the WebMethod.Post(...) function. There's no documentation that explains this API or provides an example on how it can be used. Can anyone provide some insight on how to make POST calls within Power BI?

Thanks in advance!
Martin

[Eric_Zhang · Accepted solution]

---

@mloxton wrote:

Hi all,

I'm interested in updating data sources via a REST API based on information generated from a report, but I'm struggling to understand how to use the WebMethod.Post(...) function. There's no documentation that explains this API or provides an example on how it can be used. Can anyone provide some insight on how to make POST calls within Power BI?

Thanks in advance!
Martin

---

@mloxton

May I know why you'd like to send POST request in Power BI? Usually to get data, it is to call a GET request. Anyway, you can try

below sample which calls the POST API of streaming dataset.

let
     
    url = "https://api.powerbi.com/beta/72f988bf-86f1-41af-91ab-2d7cd011db47/datasets/29f1e104-5e56-4247-8712-8f109102109f/rows?key=cZs8uA30GFpBHTi8bCSEbt2RK6fZn3QuZDnp6pgsyk1JofKe49WjSXxbBiMlqb1NXjkCb5sSHeNS52GFIxbCnA%3D%3D",
    body = "
[
{
""VALUE"" :198.6
}
]
",
    Source = Web.Contents(url,[Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(body)])
in
    Source

[vac_Consulting]

I am going to use the following to login to a web service to receive a session ID:

let
    url = "https://BASEURL:50000/b1s/v1/Login",
    headers = [#"Content-type"="application/json"],
    postData = Json.FromValue([CompanyDB = "ABC TEST", Password = "12345ABC", UserName = "ABC@USB.COM"]),
    response = Web.Contents(
                url, 
                [
                    Headers = headers,
                    Content = postData
                ]
                ),
            jsonResponse = Json.Document(response)
    in
        jsonResponse

[mloxton]

Thanks Eric!

I didn't know I could also make POST calls using Web.Contents(...).

I'm experimenting with the idea of using Power BI to update issues in our JIRA instance. Perhaps not how Power BI was intended to be used, but it could prove very useful for our team.

[jaime_blackwell]

Did you succeed at this? Could you please link me if you've shared your method as I would be interested. Thank you 🙂

[mloxton]

Bump!