Question regarding update data through direct query

[lxiaoxi]

Hi,

I am trying to do the following:

I created queries on Azure Log analytics and exported the query into Power BI query and the qury is automatically transformed into Power BI format. I loaded the query and got data from Azure database. I specified the date in the query. But what if I want to change the range of data in order to refresh the data? For example, in the query, I wrote "08/01-08/07". How could I get more data like "08/01-08/14"? I know it is not a normal data refresh.

[v-chuncz-msft · Accepted solution]

@lxiaoxi,

You may do research into The Advanced Editor.