Forum Discussion
Import list from Kusto
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?
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
2 Replies
- mahoneypat
Microsoft Employee
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
Hi Anonymous
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