Let the end user choose the query parameters used to pull data into Power BI using a direct query

[Pramit4u]

I am trying to create a report from a direct query and that query has a start date and end date parameter which is used to fulfill certain WHERE conditions, say for example  WHERE EffectiveDate>StartDate AND EffectiveDate<EndDate.

Now as far as my understanding goes the end user has only access to the Slicer and we can then let the user slice the EffectiveDate. 

But is it possible if the end user can actually provide the Start Date and End Date and the Query then pulls in Data according to that. 

 

So in my report I am using a Slicer on the field Written_Date and on my Query I have a Start and End Date which controls the Written date that is populated from the query. So is there any way I can let the user choose the start date and end date.??

[v-chuncz-msft]

@Pramit4u,

Choose DirectQuery mode and remove the WHERE condition.

[Pramit4u]

That does not solve the purpose because the direct query I am using has some where logic which cannot be really overlooked.

[Anonymous]

The bottom line is your users won't be able to affect query parameters, mostly because they can't affect regular parameters once the report is published.

I would have to see your entire query and how you're using those dates to advise further. There are a few edge-case possibilities that might be possible leveraging PowerApps alongside your report, because I believe you can modify parameters via PowerShell/Power BI API.