KQL embedded in Power Query to query Defender Log through Advanced Hunting

Hi VaibhavBhosle,

To be clear, your question is how to use KQL queries in your Power Query, correct?

If that is the case I would suggest to have a look at a couple of Microsoft examples.

I found the below is example in the Azure Data Explorer connector documentation. It demonstrates how you could use a function for your KQL queries and use those in your Power Query M.

The example is from a different type of data source, but in concept you should be able to use the same for your setup.

https://learn.microsoft.com/en-us/power-query/connectors/azure-data-explorer#provide-parameters-to-an-azure-data-explorer-function