Forum Discussion
Columns are not getting pulled through
In Microsoft Power Query, we use the Expand operation to bring related tables back together. Complex columns that can be expanded to expose the inner elements have an expand icon ( ) in the column header.
Regards,
Charlie Liao
y confusionM is that these shouldn't be merged tables, these should be fields that are part of the base table I'm using, at least according to the documentation I have. And while the data shows up fine when I try to pull it out in a report, expanding the table doesn't seem to work right, it just grabs this unrelated table's worth of fields and populates it with nulls. Because of that, I can't do any joins like this to get data organized in a way that I can set up certain visuals properly separated by categories.
Maybe this is a problem with the database, but I've just never seen it before.
EDIT: Ok, it's pulling the data through now. Still a mystery to me as to why it's behaving this way, but at least I can work with the data now.