Forum Discussion
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...
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).