Forum Discussion

pollyannaog's avatar
pollyannaog
Icon for Helper I rankHelper I
6 years ago
Solved

Log column that expands a strange problem :(

Hey, everybody, how are you? I'm facing a strange problem with query transformation in Power BI Desktop. I have a dataset where "column1" is a list of data (see image below): When I expan...
  • AlB's avatar
    AlB
    6 years ago

    Hi pollyannaog 

    Can you share a mock pbix that reproduces the problem?

    Looking at the error message it looks like PQ encounters a record where it expects a table. You could check if the item is a record with the following (it will yield true if it is a record):

    Value.Is([YourColumnName], type record)

    and then, if it is a record either ignore it in the expansion or perhaps convert it to table, depending on what you prefer.

    Please mark the question solved when done and consider giving kudos if posts are helpful.

     Cheers 

     

     

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

I am not sure what the M code of the expansion step looks like without having similar data, but if it includes an each expression (per row transformation), you could wrap the existing each function in try <existing M> otherwise "Had An Error".  That way you could refresh and see which rows are causing the error so you can investigate further.

 

Regards,

Pat

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

Regards,

Pat