Direct query issue in Matrix visual

[jayendrans]

Team,

Scenario: 

• We have some hierarchy level table of metrics in Kusto. 
• I choosed direct query option in the data source.
• Ploted a matrix to display nested rows in power BI like the below one. 
  
  

TriggerName

|

---->PipelineName

       |

       -----> ActivityName

Issue:

• After creating the matrix I just tried expanding the matrix row. And it's now giving me an actual values. Instead it's giving me an empty row. 
• The same implementation I have tried it with the Import Query option. And I was able to Expand and collapse the matrix rows properly. 
• Then I realised that in Direct query mode each and every click on the UI is performing a query execution in the underlying storage (Kusto). 
• My problem is, even if it's direct query and it's performing multiple query executions, the row expansion should work properly. But in my case it's giving me a weird look with empty rows. 
• And I feel like the Matrix visual is unstable with the direct query option while expanding the rows.

Action required:

• Just wanted to know how we can avoid this issue while expanding the matrix rows
• Also I would like to know, is there a way to avoid quey execution while expanding and collapsing the rows.

Please find the attached screenshots for reference. 

DataFields

data fields

Matrix visual - Direct query - After expanding the row: It gives an empty row values.

Matrix-DirectQuery- After expanding a row

Matrix visual - Import query - After expanding the row

Matrix-ImportQuery- After expanding a row

Thanks

@jayendrans