Passing Timeline Slicer values to SQL Query as parameters

Question

Hi,&nbsp;&nbsp;I have created a timeline slicer , with date values coming from a SQL Query.&nbsp;&nbsp;Now Depending on the Start and End Date/Times selected on the Timeline slicer , I want to dynamically pass these date values to another query, from which data in a table is generated in the report.&nbsp;Please help.

sqldev2017 · Answer

I used this same solution , by creating a report level parameter - it does work fine.&nbsp;&nbsp;I wanted to see if I can do the same using Timeline Slicer.

vanessafvg · Answer

are you working in imported mode or direct query?

sqldev2017 · Answer

My data connectivity mode is "Import"....&nbsp;I know how to modify the "Power Query M" , to pass a parameter....&nbsp;But how do i pass the Start and end Dates in the Timeline Slicer to the Query ?

vanessafvg · Answer

so you want to&nbsp;power bi timeline slicer parameter ---&gt; pass to power query ---&gt; pass to sql data source correct?&nbsp;if that is true, i am not sure how that would work as the refresh of an imported model happens before you adjust your slicer or am i misunderstanding your requirement?

sqldev2017 · Answer

So basically , this is what it is -&nbsp;&nbsp;I have a data source which has a "SQL Query"..... (I have written a SQL Query, but obviously on saving it converts to Power Query)&nbsp;I want to be able to pass the Start and End Dates from the "Timeline Slicer" as parameters to this "SQL Query"......&nbsp;&nbsp;It is the same as what is being asked here -&nbsp;https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4ed6009e-52dc-4107-81d5-80052121995a/pass-time-slicer-values-as-parameter-to-sql-query?forum=sqlkjpowerpivotforexcel&nbsp;&nbsp;

Forum Discussion

Passing Timeline Slicer values to SQL Query as parameters

8 Replies

Related content

Fabric passing parameter

Passing Parameter to warehouse

Pass Parameters to SQL Queries

Passing Parameters in measures

pass parameters to dataflow