Change query kusto in power bi online

[Anonymous]

Hello, in power bi desktop I get data from kusto, but in query kusto I use filter with one hour of time in modality direct query becuase I have more data. But if I expand datetime in query of kusto it doesn't applicate the modifications because I have too big data.

Can I change the query of kusto in power bi online for solve this problem?And if yes, how do I do?

[v-lid-msft]

Hi @Anonymous ,

When in the Direct Query mode, the data will be queried based on the slicer,filter or interaction on the report page, such as if you use pagefilter/slicer to limit last 1 hour on the column, it will query for it , if the filter/slicer changed, it will query again.

But if you filter the data in power query Editor, it can be change by query parameter in Power BI serivce, by using GUI or API.

Best regards,

[Anonymous]

---

@v-lid-msft wrote:

Hi @Anonymous ,

When in the Direct Query mode, the data will be queried based on the slicer,filter or interaction on the report page, such as if you use pagefilter/slicer to limit last 1 hour on the column, it will query for it , if the filter/slicer changed, it will query again.

But if you filter the data in power query Editor, it can be change by query parameter in Power BI serivce, by using GUI or API.

Best regards,

---

My problem is not in slicer, filter or interaction on the report page but in the query that I import data from Kusto to power bi desktop.

In the query kusto query I write "set notruncation;", but when I have problem to import million row. How can I do? I think change query online, but I don't know is it possible.

[AllisonKennedy]

@Anonymous  Have you already tried the suggestions documented here: https://docs.microsoft.com/en-us/azure/data-explorer/power-bi-best-practices