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