Forum Discussion
Pass Input Parameters to SQL Queries
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?