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

[common763]

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 data size.  We dont want them running a large query and the date will be changing daily.  Basically want to see if BI can have parameters like SSRS before a query runs.  Any info would be helpful.  

[lbendlin]

Yes, you can parameterize your query in a lot of flexible ways.  However, very soon you will hit a wall, namely the Formula:Firewall. Best read up on privacy levels and combining queries from different sources (which is basically what you'll be doing).

[common763]

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]

That would be called a Direct Query connection.

[common763]

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