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...
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.

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi sqldev2017,



      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.

      As far as I know, it is not possible to use a Timeline Slicer in this scenario currently. :smileyhappy:

       

      Regards