Forum Discussion

common763's avatar
common763
Helper III
6 years ago

SQL Server Stored Procedure with Data Parameters (Enter Date Parameters before Query Refresh)

I have a stored procedure that asks for dates before running the query.  Is there a way to have a query run inside PowerBI and before it actually runs asks for specific date parameters?  Issue is the...
Need Help
common763's avatar
common763
Helper III
6 years ago

So let me ask a different way because maybe there is an alternate approach.  If I have a dataset from SQL, where the end user could want any random start end date and the actual query or stored procedure is too large to refresh everytime it is run (without a smaller date range), what is a good easy solution that would somehow replicate what SSRS does when a report opens and the end-user selects two dates, then it goes out and gets the data? 

lbendlin's avatar
lbendlin
Super User
6 years ago

That would be called a Direct Query connection.

  • common763's avatar
    common763
    Helper III
    6 years ago

    This makes sense and is simple so appreciate it.  I will take this approach and see how it works for me.