https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1195646#M24500 <P>I have a stored procedure that asks for dates before running the query.&nbsp; Is there a way to have a query run inside PowerBI and before it actually runs asks for specific date parameters?&nbsp; Issue is the data size.&nbsp; We dont want them running a large query and the date will be changing daily.&nbsp; Basically want to see if BI can have parameters like SSRS before a query runs.&nbsp; Any info would be helpful.&nbsp;&nbsp;</P> Wed, 01 Jul 2020 16:28:13 GMT common763 2020-07-01T16:28:13Z https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1195646#M24500 <P>I have a stored procedure that asks for dates before running the query.&nbsp; Is there a way to have a query run inside PowerBI and before it actually runs asks for specific date parameters?&nbsp; Issue is the data size.&nbsp; We dont want them running a large query and the date will be changing daily.&nbsp; Basically want to see if BI can have parameters like SSRS before a query runs.&nbsp; Any info would be helpful.&nbsp;&nbsp;</P> Wed, 01 Jul 2020 16:28:13 GMT https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1195646#M24500 common763 2020-07-01T16:28:13Z https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1196002#M24505 <P>Yes, you can parameterize your query in a lot of flexible ways.&nbsp; 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).</P> Wed, 01 Jul 2020 20:18:16 GMT https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1196002#M24505 lbendlin 2020-07-01T20:18:16Z https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1196030#M24511 <P>So let me ask a different way because maybe there is an alternate approach.&nbsp; 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?&nbsp;</P> Wed, 01 Jul 2020 20:36:01 GMT https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1196030#M24511 common763 2020-07-01T20:36:01Z https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1196032#M24512 <P>That would be called a Direct Query connection.</P> Wed, 01 Jul 2020 20:37:34 GMT https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1196032#M24512 lbendlin 2020-07-01T20:37:34Z https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1198092#M24530 <P>This makes sense and is simple so appreciate it.&nbsp; I will take this approach and see how it works for me.</P> Thu, 02 Jul 2020 13:29:05 GMT https://community.fabric.microsoft.com/t5/Developer/SQL-Server-Stored-Procedure-with-Data-Parameters-Enter-Date/m-p/1198092#M24530 common763 2020-07-02T13:29:05Z