Forum Discussion

sqldev2017's avatar
sqldev2017
Microsoft Employee
9 years ago

Passing Timeline Slicer values to SQL Query as parameters

Hi,    I have created a timeline slicer , with date values coming from a SQL Query.     Now Depending on the Start and End Date/Times selected on the Timeline slicer , I want to dynamically pass...
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

so you want to

 

power bi timeline slicer parameter ---> pass to power query ---> pass to sql data source correct?

 

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's avatar
sqldev2017
Microsoft Employee
9 years ago

So basically , this is what it is - 

 

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)

 

I want to be able to pass the Start and End Dates from the "Timeline Slicer" as parameters to this "SQL Query"......

 

 

It is the same as what is being asked here - 

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

 

 

    • sqldev2017's avatar
      sqldev2017
      Microsoft Employee
      9 years ago

      I used this same solution , by creating a report level parameter - it does work fine.

       

       

      I wanted to see if I can do the same using Timeline Slicer.

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        9 years ago

        dont think so, not in imported mode.