Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error while using expander on coloums

Hi ,

 

i have just started using power BI and have encountered below issue 

 

i am using expander query on below coloum which works fine overall but wherever there is empty row i am getting a error . i cant remove error and i need those rows as well . 

 

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Familiarize yourself with the try ... otherwise ...   pattern in Power Query.  Hint: for the "otherwise"  portion you may need to provide an empty list.

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Based on my test, if your column only contains "List", it can be expanded directly.

     

    Please check if there are some "Record" in your column, too. 

     

    If so, you can refer to this post:

    transformation - Transforming json with power query (mix of list and record in a single column) - Stack Overflow.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Is this problem solved?

     

    If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If not, please let me know.

     

     

    Best Regards,

    Icey