KohrinnHelper I2 years agoDate 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 ...Show More
KohrinnHelper I2 years agoI've created two parameters and used them in Direct Query : How to connect the parameters to the values I have in slicers?
_AAndradeResident Rockstar to Kohrinn2 years agoAs you know you can do it like you want. You need to define the dates before, because the data will be loaded first.
Related contentPower Query datesFind Most Recent Date Relative to another Date Column in Power QueryDynamic Date Parameter for Import QueriesDAX Query Format Datequery parameter
