Forum Discussion
Pass Input Parameters to SQL Queries
vanessafvg Thanks for your reply.
The data in Database is refreshed everyday as new data arrives.
But I need to pass adhoc dates to analyse the past as well current data. The Timeperiod I pass can be a week or a month or any specific dates. Since multiple people will be using this report, I want to avoid back end interaction (either desktop or BI service whichever is feasible).
Thanks Again,
MS
MSingh1 cant the users just manage their own time periods via the slicers, the key for you is to bring all the data in that they might use. The only other way to only bring the data in exactly as the user requests it would be to use direct query mode, but you saying you dont want back end interaction, i am assuming by that you mean from power query to the database?
vanessafvg Users are currently managing report as per their own required time period. so a particular user goes to edit queries and invoke the query and pass say 1-Jun till 14-Jun. Then a permissions message pops up. Once accepted, data is refreshed. And then The user explores the data using date slicers on the report. to select data for a different time period, he repeats the same process.
I was hoping to find a feature so that user can invoke query from the report itself (something similar to slicers). My end objective is to host the report to BI service and allow multiple users to pass random time ranges and fetch the data.
MSingh1 well that feature is essentially a live connection do the database as opposed to importing the data into the model.
is there too much data to import all the data in or can you not change over to a live connection?