Forum Discussion
GET Request o Power BI
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.
8 Replies
Hi Williamlima ,
the error message comes directly from the web source.
I think there are more settings in Postman.
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
FonteThe way i see, i'm making something wrong on power BI, can u please help me figure it out what it is?
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
