Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Parameter - How can I change

DataBase Code URL: 

 

let
Fonte = Web.BrowserContents("http://sbripvs0022/CronetJVX//pido/getReport?p_pido=50000000681&p_table=50000000300&SHIFT_DATE2=" & Data2 & "000000&SHIFT_DATE1=" & Data1 & "000000&p_crosscompany=0&p_format=HTML&p_pagination=0&p_showtitle=0&p_showselection=0&p_paperformat=A4&p_userid=TVEN/tven@cronet_cpbritu1"),
#"Tabela extraída de HTML" = Html.Table(Fonte, {{"Column1", "TABLE.jrPage > * > TR > :nth-child(1)"}, {"Column2", "TABLE.jrPage > * > TR > :nth-child(2)"}, {"Column3", "TABLE.jrPage > * > TR > :nth-child(3)"}}, [RowSelector="TABLE.jrPage > * > TR"]),
#"Tipo Alterado" = Table.TransformColumnTypes(#"Tabela extraída de HTML",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}})
in
#"Tipo Alterado"

 

I Have 2 parameter for change de Data1 and Date2:

 

"10082020" meta [IsParameterQuery=true, List={"VAR_data2"}, DefaultValue=..., Type="Text", IsParameterQueryRequired=true]

 

and

 

"13082020" meta [IsParameterQuery=true, List={"VAR_data1"}, DefaultValue=..., Type="Text", IsParameterQueryRequired=true]

 

How can I change parameter text using a filter ? I need update those parameter in Power BI (site) too, is this possible ? without click in edit parameter.

1 Reply