Error while using expander on coloums

[Anonymous]

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 . 

[Icey]

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

[Icey]

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) - St....

Best Regards,

Icey

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

[lbendlin]

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