GET Request o Power BI

[Williamlima]

Hey guys,

So I looked in a bunch of earlier posts and still didn't' manage to make my GET request work on power BI, the configs on Postman goes like this:

Header: http://redentor.inlog.com.br:18090/dashboard/rest/exportarrelatorio

Body: {"Relatorio":"Consumo Média Planejada","Autenticacao":"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx","NomeBanco":"dashboard_inlog","Formato":"chavevalor"}

So I test it on Postman and works like a charm, but on power Query it gives me the same error"

O nome do banco de dados é obrigatório.

 wich roughly translates to "The database name is required". i have the database name on the request's body in Power Bi like this:

let
Fonte = Json.Document(Web.Contents("http://redentor.inlog.com.br:18090/dashboard/rest/exportarrelatorio", [Headers=[ContentType="application/json"]])),
body = "{""Relatorio"":""Consumo Média Planejada"",""Autenticacao"":""e0d86d356d02b3b8107d5b5015800731"",""NomeBanco"":""dashboard_inlog"",""Formato"":""chavevalor""}"
in
Fonte

Am i making something wrong? or is it incomplete? Im new to power BI so any help would be appreciated.

Thanks in advance.

[mwegener]

Hi @Williamlima ,

the error message comes directly from the web source.

I think there are more settings in Postman.

[Williamlima]

Hey  mwegener, how are you?

So the problem is that i dont know if im making the configs in Power BI right, can you tell me if the body where I put the parametersis ok? because the database name is in the body like i put earlier.

let
Fonte = Json.Document(Web.Contents("http://redentor.inlog.com.br:18090/dashboard/rest/exportarrelatorio", [Headers=[ContentType="application/json"]])),
body = "{""NomeBanco"":""dashboard_inlog"",""Relatorio"":""Consumo Média Planejada"",""Autenticacao"":""e0d86d356d02b3b8107d5b5015800731"",""Formato"":""chavevalor""}"
in
Fonte 

The way i see, i'm making something wrong on power BI, can u please help me figure it out what it is?

[mwegener]

Hi @Williamlima ,

if the body is to be transmitted, it must also be part of the webcall.

let
    Json = "{""NomeBanco"":""dashboard_inlog"",""Relatorio"":""Consumo Média Planejada"",""Autenticacao"":""e0d86d356d02b3b8107d5b5015800731"",""Formato"":""chavevalor""}",
    ToJsonBinary = Json.FromValue(Json),
    WebCall = Web.Contents("http://redentor.inlog.com.br:18090/dashboard/rest/exportarrelatorio", [Content = ToJsonBinary]),
    LinesFromBinary = Lines.FromBinary(WebCall)
in
    LinesFromBinary

[Williamlima]

mwegener , good morning.

First of all I would like to thank you for helping me out, second of all I must say that I made a little confusion on the requested method and its POST not GET and i learned a very important lesson today.

So, i managed to make the call work because Power Bi request is a GET by default and mine is a POST. So my query looks like this now:

let

url = "http://redentor.inlog.com.br:18090/dashboard/rest/exportarrelatorio",
body = "{""Relatorio"":""Controle de Desconexões de Equipamentos - MID/AVL"",
""Autenticacao"":""e0d86d356d02b3b8107d5b5015800731"",
""NomeBanco"":""dashboard_inlog"",
""Formato"":""chavevalor""
}",

Source = Json.Document(Web.Contents(url,[
Headers =[#"Content-Type"="application/json"],
Content = Text.ToBinary(body)
]
)),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)


in
#"Converted to Table"

The way I see, im converting the content to binary but i don't know how to convert back to text. Can you still help me out?.

Thank you.

[mwegener]

Hi @Williamlima,

your result looks good to me

[Williamlima]

mwegener,

Could you send me your PBIX? I'm Truly making something wrong i dont know.

Thanks.

[mwegener · Accepted solution]

Hi @Williamlima ,

here your PBIX

[Williamlima]

 mwegener ,

Thanks a lot, it really helped me out.