How to take date as an input from the line chart and alter query data

[Anonymous]

I am trying to refresh the query data based upon the date user enters or changes on the line chart itself. Is this possible anyhow, to get data from already fetched report and alter it based upon new date an input on the chart itself?

I know there is slicer thing but that actually filters the data which is already fetched. But here the challenge is to grab fresh data alltogether based upon the input date user selects or updates on the report itself.

For ex., my query uses date as an input parameter and then depicts the line chart. However, I want to refresh this query data such that user can himself sends the date an input to the query. Is it possible in Power BI anyhow?

This is something like an event is fired from the date selection on the report and accordingly the same query refreshes the data using the new date value. 

[BA_Pete]

Hi @Anonymous ,

You can't have the report amend the actual query script per se.

However, it sounds like you might be describing Direct Query behaviour. Direct Query will query the data source (not amend the query script in Power Query) each time you adjust any slicers or filters on the report:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

Pete

[Anonymous]

DirectQuery behaviour is exactly what I need, but the question is, how to use it in OData query? All I have is an OData feed wherein I am having a date parameter. Now, I need to reset this value most of the time since PBI 10k rows limitation is reached and displays incorrect results. Hence, I wanted something on the report itself, that user can edit this date himself to query fresh data again and correct results are displayed.

BTW, thanks for directing me to the direct query behaviour link. 

[BA_Pete]

Ah, no, as far as I'm aware, you can't have the enduser affect the ODATA query that is sent to retrieve data.

The only way to have enduser selections adjust the query sent to the source is using DirectQuery and, s you already know, ODATA isn't currently a DQ-supported source.

Pete