Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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. Ho...
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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