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 err...
Need Help
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.