Import list from Kusto

[athenapn]

I created a Kusto query that has a column of a list of numbers (Ex. [100, 200, 300]). When I imported this query into Power BI Desktop, the column simply says [List] and will not show the numbers. How do I fix this?

[Anonymous]

Hi @athenapn 

You could refer to the following articles:

 https://docs.microsoft.com/en-us/azure/data-explorer/kusto/concepts/ 

https://docs.microsoft.com/en-us/azure/data-explorer/power-bi-best-practices 

Best regards,

Eyelyn Qin

[mahoneypat · Accepted solution]

You can either click on the word List to drill down into the data, and the convert that to a table with the button in the ribbon. Or, if you have a column of Lists, you can click on the double arrows at the top of the column and choose "Expand to new rows".

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat