Date parameter from report

[the606]

Hi,

I am building a report based on a specific date, it is to show debts from a specific date. for example evaluating debts from last month end or today.

Currently I execute a stored proc in SQL via Excel that picks up the date entered by an end user (@asatdate) and then builds the relevant data.

I have managed to get this all working in BI but i cannot seem to work out how to get the end user of a report to be able to enter the date (dont care if its a slicer, manual entry, date picker) so that then it fires the stored proc (or the user asked for a refresh and it bring it in.

I have had a good look around im not sure if it can be done.....

 I have also got a data table in the report that i was hoping i could use

Any ideas?

[Greg_Deckler]

@the606 You would use a Query Parameter and the user would enter the date they wanted there. 

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters

I thought that there was something on the roadmap for this, you might want to check that:

https://powerbi.microsoft.com/en-us/roadmap/

[the606]

Hi Greg,

Thanks for the prompt reply.

I am going to have a good read now, however would that mean that they would have to run the report from the BI desktop app? or do you reckon i could use a list for example as a drop down on the report?

Thanks again, reading now.

[v-easonf-msft]

Hi,  @the606 

You  can check if these related thread help.

https://community.powerbi.com/t5/Desktop/How-to-do-a-Direct-Query-from-a-SQL-Server-Stored-Proc-and-...

https://community.powerbi.com/t5/Desktop/How-to-use-a-SQL-Server-Stored-Proc-with-no-parameters-as-a... 

https://community.powerbi.com/t5/Power-Query/Call-a-parameterized-query-stored-proc-and-pass-in-para... 

Best Regards,
Community Support Team _ Eason

[amitchandak]

@the606 , i doubt you can pass slicer value to query parameters