Forum Discussion
Helper IRecord column expanding weird problem :(
Hi everyone, how are you?
I'm facing a weird issue with query transformation in Power BI Desktop. I have a dataset where "column1" is a list of data (see image below):
When I expand "column1" it seems that it is a colum with list of records, with some null rows (see image below):
So, I again apply an expansion, now in this records column. Then, it seems that everything worked fine (see image below):
BUT...when I apply all the transformations, Power BI shows this error:
Its seems that few row records that were expanded did not matched the expected structure. I've tried a lot of transformations without success and searched on Web, but I can't find a solution for this. Anyone could help me?
Thanks!!!
5 Replies
- Greg_Deckler
Community Champion
Maybe the null's are causing problems?
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
pollyannaogI've tried to deleted nulls, but it was not the problem. I saw that there is a row that did not match the columns expected from majority of records (it has a different column inside the record, that do not have in other records). So it breaks the transformation flow...
- Greg_DecklerAny chance you can just wipe that row?
