How to pass parameters to Power BI at Runtime/Refresh Time

[Anonymous]

Hello,

I am migrating a report to Power BI.  In the original report, a user enters 2 parameters, a Start Date and End Date.

These are then passed to a query and used in a WHERE Clause.  (i.e.  Where Start Date = Parm1 AND End Date = Parm2).

Can I place any needed parameters in a spreadsheet and have PBI load the parms and use them in a WHERE clause?

Thanks in advance

[amitchandak]

@Anonymous , First Create a query using advance editor and then right click in open that in advance editor

a string will use for sql

like

"Select * from Tab"

Modify that

"Select * from Tab where date= '" & [Date param] & "'"

use Date.Text  is case a format is need

[Anonymous]

Hello Amitchandak,

Can you contact me via email regarding my question?

I'm not sure how to create the query in the Advanced Editor.

Can we meet briefly via MS Teams or Zoom?

Thanks very much,
Rich
rstringer.cw@mmm.com