Forum Discussion

dobregon's avatar
dobregon
Impactful Individual
5 years ago
Solved

Filter SQL query using parameters

Hi guys,   I want to take values from a table in my SQL server but i want to filter the query acording a parameter.   Imagine that i have a million of rows about daily values of customers and i w...
Need Help
  • dobregon's avatar
    dobregon
    5 years ago

    Thanks edhans 

     

    In reality, that i didnt understand is what simply was to put the same name than the parameter in the powerquery and this will filter the query... 

    i just find the new video from  Patrick that it is very visual to see what i'm looking for and for future visitors to this topic.


    Thanks edhans  and CNENFRNL  for your support!



dobregon's avatar
dobregon
Impactful Individual
5 years ago

Thanks edhans 

 

In reality, that i didnt understand is what simply was to put the same name than the parameter in the powerquery and this will filter the query... 

i just find the new video from  Patrick that it is very visual to see what i'm looking for and for future visitors to this topic.


Thanks edhans  and CNENFRNL  for your support!



Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for the parameters (Dates) this is helpful.  Does this really impact the refresh load?  As that is my expectation.  So if my general ledder SQL table has 1,500,000,000 rows I and 10 years of GL data.  I don't want it all and just really need Last three months of the pervious year and the current year.  So two sets of parameters with from and to date each.  Or is there a more lean way to parameterize this. With two datasets for GL data previous year last three months and current year; and then I append one to ther other for a sinble dataset and have one not refresh.  Your thoughts. Please