Forum Discussion
Date parameters in SQL query
Hi,
I have a large table in SQL with data that are growing pretty fast. I don't want to import the whole thing to Power BI, just to choose from slicers the start and end dates and get only the data that I need based on slicers. How do I do that?
Thanks!
4 Replies
If you are using import mode please check this post: https://community.fabric.microsoft.com/t5/Power-Query/Dynamic-Date-Parameter-for-Import-Queries/m-p/1428793#M44641
Other option is using direct query. With direct query the data remains on your server and the PBI send the query request data when you filter the visualI've created two parameters and used them in Direct Query :
How to connect the parameters to the values I have in slicers?
As you know you can do it like you want. You need to define the dates before, because the data will be loaded first.
My issue now is how to bind my parameter to the selected date on slicer.
