Invoking rest api post call in PowerBi

[Anonymous]

I am trying to invoke a post-call in PowerBi using a custom query but I'm facing an error The post-call gets converted to a get call and it throws an error. I tried using basic auth directly and also by passing it in headers any advice or help is appreciated and thank you in advance.

let StartDate =Date.ToText(TimeStart,"yyyy-MM-ddTHH:ss:SSZ"), EndDate =Date.ToText(TimeEnd,"yyyy-MM-ddTHH:ss:SSZ"), auth_key ="Basic ZHNwX3JldGluZ191c2VyOk9DSXJlcG9ydHNAMjAyMA==", body = "{""tenantId"": "&tenancyName&",""granularity"": "&Duration&",""timeUsageStarted"": "&StartDate&",""timeUsageEnded"": "&EndDate&",""queryType"":"&CostType&",""groupBy"": ""[service]""}", Data= Web.Contents("http://localhost:8080/costanalysis?profile=str109348123&region=london", [Headers=[#"Content-Type"="application/json", Authorization=auth_key]]), Content = Text.ToBinary(body), DataRecord = Json.Document(Data), Source=DataRecord in Source

This is the error in Bi

DataSource.Error: Web.Contents failed to get contents from 'http://localhost:8080/costanalysis?profile=str109348123&region=london' (405😞 Details: DataSourceKind=Web DataSourcePath=http://localhost:8080/costanalysis Url=http://localhost:8080/costanalysis?profile=str109348123&region=london

This is the stack error in JAVA end

c.d.o.exception.GlobalExceptionHandler : Something went wrong.Error Message : Request method 'GET' not supported 2020-12-29 11:27:53.260 WARN 20696 --- [nio-8080-exec-1] .m.m.a.ExceptionHandlerExceptionResolver : Failure in @ExceptionHandler com.dsp.oracle.exception.GlobalExceptionHandler#defaultErrorHandler(HttpServletRequest, Exception) 

[Anonymous]

Thank you it worked

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

You have the Content outside the Web.Contents call.  It should be like this

let 
    StartDate = Date.ToText(TimeStart,"yyyy-MM-ddTHH:ss:SSZ"),
    EndDate = Date.ToText(TimeEnd,"yyyy-MM-ddTHH:ss:SSZ"),
    auth_key ="Basic ZHNwX3JldGluZ191c2VyOk9DSXJlcG9ydHNAMjAyMA==", 
    body = "{""tenantId"": "&tenancyName&",""granularity"": "&Duration&",""timeUsageStarted"": "&StartDate&",""timeUsageEnded"": "&EndDate&",""queryType"":"&CostType&",""groupBy"": ""[service]""}",
    Data = Web.Contents(
        
            "http://localhost:8080/costanalysis?profile=str109348123&region=london", 
    
            [ 
                Headers = [#"Content-Type"="application/json", Authorization=auth_key],
                
                Content = Text.ToBinary(body)
            ]
            
            ), 
                  
    DataRecord = Json.Document(Data), 
    Source = DataRecord 
    
in 
    Source

Because the Content was in the wrong place, Web.Contents was making GET requests rather than POST.

Regards

Phil

[Anonymous]

When I publish this it throws an error saying anonymous call error but other calls work fine as they have data source by default as basic auth

[amitchandak]

@ImkeF , can you help on this.

[amitchandak]

@Anonymous , For post method refer these two, if they can help, if not explored previously

https://community.powerbi.com/t5/Desktop/Pull-data-from-API-using-POST-method-in-Power-BI/td-p/574727

https://www.thebiccountant.com/2018/06/05/easy-post-requests-with-power-bi-and-power-query-using-json-fromvalue/

[Anonymous]

I tried those but it didn't work. PowerBi still throws an error for basic auth or anonymous call either way the post gets converted to get by powerBi and authorization fails