cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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 these date values to another query, from which data in a table is generated in the report.

 

Please help.

8 REPLIES 8
Highlighted
Super User I
Super User I

Re: Passing Timeline Slicer values to SQL Query as parameters

are you working in imported mode or direct query?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper I
Helper I

Re: Passing Timeline Slicer values to SQL Query as parameters

My data connectivity mode is "Import"....

 

I know how to modify the "Power Query M" , to pass a parameter....

 

But how do i pass the Start and end Dates in the Timeline Slicer to the Query ?

Highlighted
Super User I
Super User I

Re: Passing Timeline Slicer values to SQL Query as parameters

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper I
Helper I

Re: Passing Timeline Slicer values to SQL Query as parameters

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

 

 

Highlighted
Super User I
Super User I

Re: Passing Timeline Slicer values to SQL Query as parameters

happy to be wrong but dont think that is possible in imported mode, in direct query that would happen automatically i would think as its only looking at live data.

 

maybe this post can offer more info or a work around

 

https://community.powerbi.com/t5/Desktop/How-do-I-pass-parameters-to-my-SQL-statement/m-p/119671

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper I
Helper I

Re: Passing Timeline Slicer values to SQL Query as parameters

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.

Highlighted
Super User I
Super User I

Re: Passing Timeline Slicer values to SQL Query as parameters

dont think so, not in imported mode.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Microsoft
Microsoft

Re: Passing Timeline Slicer values to SQL Query as parameters

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

 

Regards

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors