Use stored procedure parameters with dates in PowerBI as a slicer

[Mariusvandyk123]

Hello, We have a project coming up where we will be migrating all our current SSRS reports to PowerBI. The SSRS reports use stored procedures. We need to have the same look and feel as SSRS. What I am struggling with is the stored proc parameters. The start and end date are part of the select list and I tried to build a slicer that will emulate the SSRS report but still no luck. Can someone help me get the start date and end date slicers to work or should i use the parameters option in PowerBI? 

[amitchandak · Accepted solution]

@Mariusvandyk123 , refer if this can help

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...

or

https://databear.com/sql-stored-procedures-in-power-bi/

[Mariusvandyk123]

I see my version of PowerBI does not have the "Edit Query" option in the Ribbon bar. I've searched for it everywhere?

[Mariusvandyk123]

Sorry, it's "Edit Queries" i am looking for. 

[Mariusvandyk123]

Thanks a lot. Will try it out.