Date parameters in SQL query

[Kohrinn]

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!

[Kohrinn]

My issue now is how to bind my parameter to the selected date on slicer.

[Kohrinn]

I've created two parameters and used them in Direct Query :

How to connect the parameters to the values I have in slicers?

[_AAndrade]

As you know you can do it like you want. You need to define the dates before, because the data will be loaded first.

[_AAndrade]

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

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 visual